SQL Database Administrator
Philadelphia, PA 19103(3 days a week)
Phone and Video
Long Term
W2 Only
Job Description : Responsibilities :
Responsibilities :
This posting is for a Senior SQL Server Performance Database Administrator.
The position will work directly with various IT associates including Application Development, Server Admin, Networking, Database Administration, and others to optimize application / database performance.
Candidate should have hands on experience with large scale environments and high transaction volumes.
The ideal candidate should have extensive Java experience.
Experience with Mule would be a plus, but not required.
Specific Duties :
1. Advanced Database Development experience with Microsoft SQL Server Database.
2. Experience with Senior level Database Administration support. (e.g., Installing / Upgrading / Backup and Recovery / Configuring / SSMS / SSIS / SSRS / Always on Failover Clustering / Performance Tuning / Troubleshooting).
3. Evaluating SQL Server Query performance. Providing guidance on query redesign, index modifications, database configuration changes, and database related application process improvements.
4. Utilizing Idera SQL Diagnostic monitor, Query Store, SQL Server Profiler, Dynatrace and Query plans to evaluate and tune database queries.
Evaluating index statistics / fragmentation.
5. Creation of SQL Server performance documentation / best practices for consumption by SQL Server Database Development and Database Administration teams.
6. Participate in evaluations and recommendations for associated database solutions based on business requirements and user needs.
7. Provide performance monitoring and measuring of all database components and provide input on capacity and performance planning.
8. Escalate issues for technical assistance as required.
9. Participate in basic to moderately complex database tuning efforts as required.
10. Apply administration best practices in daily operations.
Qualifications :
BA / BS in Computer Science, Information Systems, or related field, or equivalent knowledge acquired by work experience and training.
Industry-recognized technical certification preferred (e.g. SQL, MCDBA)
Working Knowledge of database file structure, retrieval and access methods, and performance analysis. Demonstrated analytical skills, excellent written and verbal communication skills, judgment, and the ability to work effectively with clients and IT associates in a collaborative and cooperative manner.
Basic Understanding of the development process and business process.
10+ years' related IT experience working as a SQL Server database administrator and familiarization with related technologies and tools.
The candidate should have Database Development experience in large scale environments with high transaction volumes such as ecommerce or banking.
Pankaj Kumar
Lead IT Technical Recruiter
Phone : 321-766-9495
Email : [email protected]
Gtalk : [email protected]
Sr. SQL Database Administrator
SQL Database Administrator</font></p> <div> </div> <div><font face="arial, sans-serif">Philadelphia, PA 19103(3 days a week)</font></div> <div> </div> <div><font face="arial, sans-serif">Phone and Video<...
Senior Sql Database Administrator
Experience and knowledge of AWS data analytics tools such as Athena, Glue, RedShift, RDS, Step Functions and other databases such as MS SQL Server. Strong knowledge of database design, data modeling, and data warehousing principles. Proficiency in SQL and experience with programming/scripting langua...
Lead, Infrastructure Security Engineer - Data Protection
As a Lead, Infrastructure Security Engineer on Security Service Data Protection team, you will partner with product owners, designers, engineers, and delivery professionals to improve Prudential’s capabilities for our Cyber Defenders. Technology - Engineering & Cloud. You will provide technical ...
SSIS/ SQL Data Engineer
JOB TITLE: </b><b>SSIS/ SQLw/d ETL EXP</b></p> <p><b>LOCATION</b><b>: New Jersey </b><b>(HYBRID / C2H)</b></p> <p><b>CLIENT: VIRTUSA</b></p> <p><b> </b></p> <p><b>J...
Principal Data Engineer
Minimum of 15+ years of related big data engineering experience modeling and developing large data pipelines and platforms<br /> Hands-on experience with distributed systems such as Spark, Hadoop (HDFS, Hive, Presto, PySpark) to query and process data<br /> Expert in Python and SQL skill...
Sr. Analyst of Risk Adjustment Data
Bring your experience with healthcare analytics experience to an established insurer and play an active role in submission, monitoring, and contributing to the end-to-end Risk Adjustment Data Submission and Validation. You will be responsible for oversight and participation in projects including tim...
Azure/Snowflake Data Warehouse Engineer
Proven experience (5+ years) in data engineering, with a focus on data warehousing, ETL, and data modeling. We are seeking a skilled Senior Cloud-Based Data Engineer to join our dynamic technical team that supports the Investment Management line of business and the transformation initiatives current...
MULTIPLE OPENINGS [Data Analyst Position]
Seeking qualified Data Analyst w/Master’s in Business Analytics or IT with months of work experience to Perform ETL to load clients’ data from heterogeneous sources in internal data warehouse using SQL and Access during every report period and maintain data pipeline from Access to ZM database and pr...
Data Analyst and computer software engineer
Data Analyst and computer software engineer to join our creative team. Understand the day-to-day issues that our business faces, which can be better understood with data. Compile and analyze data related to business' issues. Develop clear visualizations to convey complicated data in a straightforwar...
Microsoft Access Database Administrator
As the Microsoft Access Database Administrator, you will be responsible for maintaining and enhancing the performance of our Microsoft Access databases and applications. Microsoft Access Database Administrator. Manage Microsoft Access databases, including upgrades, migrations, and troubleshooting. M...