SQL Server Database Administrator Role
This role focuses on the design, development, and maintenance of SQL Server databases to ensure optimal performance, security, and reliability.
The ideal candidate will have extensive experience in database administration, with a strong understanding of SQL Server architecture and best practices.
* Maintain database performance, availability, and security through proactive monitoring and issue resolution.
* Collaborate with developers to optimize database queries and schema enhancements.
* Implement automated processes for routine tasks, such as tracking issues and documenting system changes.
About the Position:
* 4+ years hands-on experience in SQL Server Administration
* 2+ years of experience with Performance Tuning and Optimization (PTO)
* Monitor and optimize database performance using index tuning, dmv, and other methods.
* Manage High Availability (HA) databases, database backups, and disaster recovery.
* Design and develop SSIS packages for data transformation, loading, and extraction.
* Experience in supporting batch interfaces via SSIS.
* Create and implement database solutions (tables, stored procedures, etc.) and manage data migrations from legacy systems to new platforms.
* Experience in financial data reporting, data migrations, analysis, and standardization, with strong database design and SQL Server development skills.
* Knowledge of Amazon Aurora, RDS, Redshift, Dynamo DB, or MongoDB.
* Experience with DevOps, CI/CD pipelines, Agile processes, and tools like Visual Studio and SQL Server would be a plus.