About the Role
- Responsible for maintaining and evolving current platforms, assimilating new platforms, and helping drive strategy for scalable operations
- Ideal candidate is comfortable with both cloud and on-premise database administration.
Requirements
Deploy and Configure SQL Server Services (Database Engine, Reporting Services, Integration Services) in production and non-production environments.
Establish pro-active monitoring of production databases and related systems to identify capacity and performance issues
Determine ways to improve performance by suggesting configuration changes, tuning, indexing, query changes, etc.
Assist in optimization of queries, stored procedures, and their usage to maximize performance while satisfying business requirements.
Design, plan, implement, and test automated backup and disaster recovery processes.
Work with leadership to develop and maintain data governance processes
Coordinate with other technical and business teams to solve database level issues.
Support Agile development efforts balanced with longer-term continuity, stability, and enterprise operational issues.
Design, implement, and administer automated ETL processes for data cleaning, archiving, and warehousing.
Key Qualifications:
Bachelor's degree in computer science, systems analysis or a related study, or equivalent experience
At least 5 years experience with SQL Server
At least 7-10 years experience in varied technical disciplines such as software development, database design,
Understanding of relation database design principles.
Experience with cloud database platforms like Azure SQL Server and Azure Synapse
Experience with enterprise database administration and high-availability production environments
Demonstrated experience in working on root cause analysis for SQL Server database issues.
Experience with database performance monitoring tools like Profiler, Spotlight, Foglight, Red Gate, etc.
Experience with deploying SQL Server in virtualized environments. (VMWare, AWS)
Exposure to both transactional/operation database design and data warehouse design
Ability to apply deep knowledge of DB platforms to optimize DB query performance.
About the Company