Database Administrator

Job Responsibilities

• Implement and maintain change control and testing processes for modifications to databases.
• Collaborate with application development staff to develop appropriate database architectures, coding standards and quality assurance procedures.
• Participate in installation, configuration and testing of database systems (new and upgrades).
• Consult with infrastructure staff, developers, QA and others as needed to assess the impact of new database releases and patches.
• Monitor performance of database systems, including stored procedures and execution time.
• Optimize database performance, implement changes and apply new patches and versions when required.
• Develop and implement effective data backup and recovery plans, storage and archiving processes, replication strategies and disaster recovery procedures.
• Control access permissions and privileges to maintain data integrity and security.
• Plan and coordinate data migrations between systems.
• Provide long-term perspective on the relationship of database technology to the business opportunities facing the company, optimum access techniques, appropriate maintenance plans, and effective capacity planning.
• Assist IT Production Control team by performing code deployments and helping configure job schedules.
• Maintain professional and technical knowledge, including industry best practices. Demonstrate commitment to continuing professional development.

Job Requirements

• Bachelor of Science (BS) degree in an Information Technology (IT) discipline or related field.
• 5 years of MS-SQL experience, including SQL Server Management Studio (SSMS), SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS).
• Experience with SQL Server in Azure (PaaS/SaaS), including Azure SQL Database and Managed Instance, with skills in deployment, monitoring, performance tuning, and security.
• 2 years’ experience in a database administration role.