SQL DBA

Database Administrator Boston, MA

JO-1611-312

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 The Ceres Group