Now Hiring an Expert Senior SQL Application DBA
As an Expert Senior SQL Application DBA, you will work with a major financial services industry leader on their core production systems. Top professionals are needed to discover areas for improvements and solve complex application and data related issues in a critical enterprise system. Join our team of Data and Azure professionals and accomplish what others only dream of. This is a remote position with occasional travel to Chevy Chase, MD.
Review application database telemetry for issues and prioritize their resolution based on overall application impact
Experience working with Application Architects to solve complex Enterprise application issues.
Experience working on performance issues with very large databases backing critical and high-volume applications.
Devise solutions to application database issues and deliver them individually or by working through others
Determining sequence and timing activities such as batch processes, backups, etc. to improve database performance.
Maintain, backup / restore, and monitor any and all Microsoft SQL Server environments.
Assist system architecture teams with hardware, software, and configuration requirements.
Provide ongoing database support in multiple-cluster production environment.
Help define database back-up & recovery strategy including archiving strategies.
Provide input, as needed, to the development of business cases when enterprise-wide database solutions are proposed.
Assist the technical application team with application-level SQL query design to ensure efficiency and performance within the SQL database.
Develop and implement system and database performance monitoring processes.
Analyze monitoring data for performance optimization opportunities.
Manage the on-site backup and recovery process and / or support of the off-site backup strategy.
Plan for and perform any required database upgrades and migration (patches, etc.).
Maintain current industry knowledge of development concepts, best practices, and procedures for Microsoft SQL Server.
Assist the technical application team with database migrations and single data loads.
Profile of Success:
10+ years of extensive experience with SQL Servers
Exposure to SQL 2019
SME Level experience with SQL database triage and issue resolution
Experience optimizing/tuning stored procedures and functions
Experience analyzing and modifying indexes to improve database performance
Perform data profiling using SQL
Prototype ETL transformation logic using Advanced SQL techniques
Desirable Skills :
Duck Creek experience