Senior Database Administrator - MS SQL

Reporting to the Manager, Database Administration, the Senior Database Engineer will provide timely and quality database design, development, maintenance, and problem resolution services for internal and external customers. They will manage highly resilient corporate and cloud database infrastructure utilized by GHX DaaS/SaaS solutions. 

The Sr Database Engineer will work with various operational and development teams to plan, design and implement and support core database functionality that meets company initiatives with respect to performance, scalability, reliability, and adherence to operational policies and principles. At GHX we believe in fostering a diverse and inclusive workplace where everyone feels valued and supported. We are committed to building a team that represents a variety of backgrounds, perspectives, and skills.

Roles and Responsibilities:

• Administration and management of GHX databases, including: 
• Backup and recovery 
• Monitoring of data database capacity and performance 
• Security and data access management 
• Installations, upgrades, and patching 
• Fail over server management 
• Development and engineering of GHX databases (in collaboration with architects and software developers), including: 
• Database design/modeling and master data management 
• Object creation (dml, ddl and dcl)  
• Familiarity with Object Relational Mapping (ORM) tools a plus 
• Performance tuning 
• Logical to physical data model implementation 
• ETL process design and management 
• Release Management/Continuous Integration 
• Reporting and metrics development, analysis and presentation 
• Safeguard the company's data, tools and information systems by adhering to Operational and Security policies and procedures throughout lifecycle of service delivery. 

• 24/7 monitoring, on-call support and troubleshooting database issues, provide operational feedback to development and release teams. 

• Evaluating and recommending upgrades and new database tools and technologies as appropriate for the enterprise. 

• Provide guidance and assistance to junior database engineers 

• Implement and maintain automated processes using standardized shell scripting tools. 

• Develop database engineering standards and practices for the secure operation of databases between our cloud environment, customer environments and third-party IaaS vendors/providers 

• May manage relationships with hardware vendors and ISPs 

• May coordinate the activities of other database engineers 

• May represent database services team for technical issues during cross functional meetings/stand-ups
• Ability to contribute different thoughts, ideas and viewpoints that lead to greater innovation on projects and cross-functional collaborative efforts

Required Experience: 

• 5-8 years’ experience in MS SQL Database Administration 

• In depth knowledge of one RDBMS platform Primary MS SQL  (Knowledge and willingness to learn PostgreSQL, Oracle and MySQL)
• Experience with cloud hosted databases , AWS preferred  

• Part of a support organization involved in implementation projects 

• Proven ability to manage databases in a high transaction/high availability environment 

• Experience with horizontal scaling and high availability technologies/concepts (ie SQL Server ‘Always On’ etc) 

• Hands on experience with Windows operating systems in a physical and/or virtual environment  

• Experience working with project managers/scrum master’s to implement new projects and resolve issues 

• Liaising directly with customers of an IT organization 

• Exposure to ITIL / ITSM / Managed Services / DevOps / SOA operational models 

• Very strong SQL and T-SQL development and tuning skills 

• Knowledge of higher-level languages a plus (Java, C++, Python) 

Required Qualifications: 

• Bachelor’s degree from an accredited college in CS or related discipline or equivalent experience 

• Strong critical thinking, analytical and problem-solving skills  

• Interpersonal skills with a strong orientation towards customer service 

• Excellent written and oral communications skills with demonstrated commitment to production of high-quality documentation 

• Excellent team player with good experience working with departmental and cross functional teams 
• We are looking for someone who is proficient in the role requirements, but wh