The Senior Database Developer / Administrator is primarily responsible for ensuring the availability and optimization of our production, development, and QA database environments. Candidates must have experience with database development and database administration on the SQL Server platform, preferably in an Agile environment. A solid understanding of SQL Server internals and the ability to spot problematic areas, analyze solutions, propose resolutions and direct their implementation is essential. The candidate will work with the team to provide technical expertise and guidance to multiple delivery teams in a DevOps environment. A successful candidate is a motivated self-starter with an aptitude for learning new skills and environments quickly while multi-tasking on more than one deliverable.
Responsibilities:
• Ensure that the firm's databases are available to end users at all times, 24x7x365, including on-call rotation
• Provide guidance to delivery teams to ensure that database code is optimized, scalable, and meets standards
• Implement enhancements and updates to ensure database technology is current
• Efficiently and effectively troubleshoot problems in all environments as they arise
• Ensure that database and query performance are optimized
• Identify and remediate performance issues in the production environment before they impact the business
Qualifications:
• Bachelor's degree in computer science or a related technical field is preferred.
• 5-8 years of closely related experience with Microsoft SQL Server 2012 and later; Additional Microsoft database related technologies such as SSIS, SSRS, and SSAS
• Exposure to Agile software methodology and CI/CD tools and practices
• Advanced T-SQL programming, performance, and optimization techniques
• Experience with backup/recovery tasks, user administration, and SQL Server installation and configuration
• Strong understanding of database replication technologies, configuration and performance in a clustered environment
• Software development or scripting experience (powershell, python, C#, etc.)
• Windows Server 2008/2012, Linux, Sybase ASE 15
