Company:
A2C
Location: Philadelphia
Closing Date: 03/11/2024
Hours: Full Time
Type: Permanent
Job Requirements / Description
W2 Only - no Third parties
Exciting opportunity for a Senior SQL Server Developer/DBA with out direct client in Philadelphia, PA. In this role you will work 3 days/week in Philadelphia, PA.
Specific Duties:
- Advanced Database Development experience with Microsoft SQL Server Database.
- 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).
- Evaluating SQL Server Query performance.
- Providing guidance on query redesign, index modifications, database configuration changes, and database related application process improvements.
- Utilizing Idera SQL Diagnostic monitor, Query Store, SQL Server Profiler, Dynatrace and Query plans to evaluate and tune database queries.
- Evaluating index statistics/fragmentation.
- Creation of SQL Server performance documentation/best practices for consumption by SQL Server Database Development and Database Administration teams.
- Participate in evaluations and recommendations for associated database solutions based on business requirements and user needs.
- Provide performance monitoring and measuring of all database components and provide input on capacity and performance planning.
- Escalate issues for technical assistance as required.
- Participate in basic to moderately complex database tuning efforts as required.
- 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.
- Basic Understanding of the development process and business process.
- Ten (10) or more 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.