We are looking 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:
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:
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.