As our database administrator, supporting the firm's databases, monitoring our systems, writing documentation on current systems design, and providing guidance on future database implementations to support our company's data will be all in a day's work. This collaborative position will have you working closely with IT project managers, developers, and the Systems Engineering team-communicating regularly with application and operational staff to ensure database integrity, security, and quality. This position will focus on Microsoft SQL Server, but occasionally you'll be required to support non-Microsoft databases, too.
Responsibilities:
Supporting internally developed database environments, as well as third-party database environments
Ensuring that all databases are being backed up and that recovery procedures are functioning to meet recovery point objectives and recovery time objectives
Installing, configuring, and patching all SQL Server instances to keep them at appropriate patch levels, in accordance with IT and security policies
Evaluating and testing new database solutions and enhancements
Meeting business requirements for high availability and disaster recovery for all supported environments
Writing database documentation, standards, and procedures; educating database users on how to efficiently query the database system
Operationalizing and enforcing standards for the processes and procedures for production code releases
Deploying database schema change scripts provided by third-party vendors or in-house developers
Configuring SQL Server monitoring and alerts to help manage database systems; identifying database server weaknesses and recommending solutions
Designing, building, and maintaining custom DBA utilities/tools to better support the database environment
Ensuring that our database servers meet company standards and follow industry best hardware and software practices
Participating in the on-call rotation for the Database Administration/Operations team Qualifications:
3+ years' DBA experience with SQL Server
Enterprise-level database operations experience
Excellent communication skills
Experience with SQL Server HA and DR technologies (log shipping, failover cluster instances, availability groups)
Experience with performance tuning, including third-party databases, where code changes are not possible
Experience writing automation using scripting languages such as PowerShell The ideal candidate will also have familiarity with SOME of the following technologies:
Oracle, MySQL, PostgreSQL, or other database platforms
Visual Studio .NET
Windows Server Failover Clustering
SQL Server Reporting Services and SQL Server Integration Services
Microsoft Azure or other cloud infrastructures