Responsibilities
- Provision and configure SQL Server instances for both new and existing products
- Ensure performance, security, and availability of databases.
- Implement world-class database monitoring and alerting to ensure DBA is proactive in monitoring active events and proactive in preventing events such as low drive space, fragmented indexes, etc.
- Plan, implement, and maintain replication strategies.
- In depth analysis of performance, identification of areas of improvement, and implementation planning.
- Prepare documentation, procedures, and specifications.
- Handle common database procedures such as upgrade, backup, recovery, migration, etc.
- Profile server resource usage, optimize and tweak as necessary.24x7 Support of Production DB’s
- Solid working knowledge performing OS/DB migrations on prem and in azure environments/Installation, configuration, and support of SQL Server Integration Services, Reporting Services
- Support and maintenance of BI reporting platform.
- Participate in the creation, revision, and execution of project plans, including identifying resource needs, performing quality review, and escalating functional, technical, and organizational issues where appropriate.
- Windows Server Administration/Scripting – PowerShell, Python, and shell scripting are all good
- Perform other duties and assist with projects as assigned.
Requirements
- Experience serving as DBA lead
- Experience in T-SQL and other developer tools used to support programming that include new functionality, automated interfaces, and/or enhancements to vendor-provided software
- Knowledge of de-facto standards and best practices in SQL Server
- Strong proficiency in SQL Server database management and administration including with large scale SQL Server databases.
- Hands-on experience implementing and maintaining Always-On Availability Groups is required. Knowledge of additional replication models is a plus.
- Experience working with SQL Server Integration Services (SSIS) and ETL jobs.
- Proficient in writing and optimizing SQL/T-SQL queries and jobs.
- Experience with backup and recovery strategies.
- Bachelor’s degree in an Information Technology-related field or related work experience
- 5 years of related database administration and application infrastructure experience
- Ability to work effectively with both technical and non-technical staff, including coordinating and planning of work efforts
- Must have excellent organizational, planning, and technical skills to diagnose problems in an environment with constantly changing priorities
- Excellent verbal and written communication skills
- Strong analytical and quantitative skills
- Ability to document associated programs and integrations
- Team leadership and collaboration skills
- Ability to work on small-to-complex projects that require skills in multiple technical environments
- Ability to handle multiple projects/tasks simultaneously
- Knowledge of project management disciplines/methodologies and change management.
- Excellent time management skills
- Knowledge of related security best practices
Nice to Have
- Master’s degree
- Project Management Institute (PMI) Project Management Professional (PMP) or related experience
- SolarWinds DPA or similar monitoring solution
Benefits
- Comprehensive Health Care, Vision & Dental Plan
- Flexible Spending Account
- Disability Plans
- Basic & Supplemental Life Insurance
- Additional Supplemental Benefits
- Paid Vacation, Paid Time Off (PTO) days, Holidays
- 401(k) Retirement Saving Plan including a generous Company match
