Database Operations Engineer

Job Description

Overview:

• Strategy
• nWork with development staff to firm-up/harden database architectures, coding standards, and quality assurance policies and procedures.
• nDesign and implement redundant systems, policies, and procedures for disaster recovery and data archiving to ensure effective protection and integrity of data assets.
• nResearch analysis and recommendation regarding database products, services, protocols, and standards in support of future database platform design/delivery/management efforts.
• nOperations/Config Management
• nSQL database management across development, QA and production environments
• nDatabase performance and capacity management monitoring
• nDatabase maintenance activity implementation (backup/recovery, rebuilding/reorganizing indexes, etc)
• nDatabase release versioning/assessment/measurement from a functionality and performance perspective
• nTechnical expertise/guidance on database design (Logical and Physical modelling) and development
• nDemonstrate SQL expertise related to performance tuning of database schema, stored procedures, etc
• nFailover Cluster/HA set-up/configuration/management
• nDatabase management activity automation using PowerShell, SSIS, and other technologies
• nSystem monitoring, metric reporting, and diagnostics

• Excellent time management, resource organization and priority establishment skills with the ability to multi-task in a fast-paced, deadline-oriented environment
• nKeen attention to detail
• nAbility to work with an optimistic attitude both independently and as part of a team

nQualifications Required:

nEvery organization has a culture, whether they mean to or not, so why not be intentional about itn

Together, if we shape our intentions, actions, and interactions around a common, purposeful culture, we are able to quickly achieve more, attract others who help realize our goals, and thrive in our professional relationships.

• nBS degree in computer science or related field and/or at least 5-7 years equivalent work experience
• nExperience with Microsoft SQL Server Clustering, Replication, and Always On
• nExperience with database technologies, such as MS SQL Server 2012/2014, MySQL 5.1 and above, AWS RDS, Postgres, MongoDB, and Sybase
• nExperience in performance tuning, query optimization using Performance Monitor, SQL Profiler or other related tools
• nExperience resolving database integrity issues, performance issues, blocking/deadlocking issues, connectivity issues, and data replication issues