Job Description

This is a MS SQL Server DBA III role largely responsible for providing operational database services to the organization. Some of the primary responsibilities of this role would include owning, tracking and resolving database related incidents and requests, fulfilling requests and resolving incidents within SLAs, reviewing service related reports (e.g.: database backups, maintenance, monitoring) on a daily basis to ensure service related issues are identified and resolved within established SLAs, responding to database related alerts and escalations and working with database engineering to come up with strategic solutions to recurring problems.


What You'll Do

• Install and upgrade SQL Server RDBMS and related products: Keep SQL Server RDBMS at current release and maintenance levels; provide current & stable production and development environments.
• Provide first-level application support: Resolve problems and answer questions related to the SQL Server RDBMS and platform environment; contact vendor support when necessary; facilitate application development and client problem resolution with optimum speed and efficiency.
• Reorganize database structures as needed: Automate procedures at regular intervals; use tools to reorganize or de-fragment database table spaces, tables, and indexes; provide efficient database environment to maximize productivity and improve performance.
• SQL Server RDBMS performance monitoring and tuning: Closely monitor performance; identify problems and implement solutions; ensure the database is running at optimum speed and efficiency.
• Perform database refreshes upon request: refresh data from one environment to another at the request of the application development staff, execute necessary tasks to accomplish this, to minimize impact provide application development staff optimal development environment with current data.
• Maintain database backup/recovery environment: Respond quickly to refresh data; verify implementation of correct backup strategy, develop recovery procedures; support recovery from loss of data caused by user or system error.
• Experience working closely with a cross functional team consisting of employees, contractors, and vendors with various skills and disciplines.
• Engages with IT external partners to ensure SLAs are met and company processes and policies are adhered to.
• Ensure database availability, performance, and supportability can meet application requirements.
• Ability to work with application groups to determine those requirements.
• Engage with internal and external auditors on database security and compliance issues.
• Performance tuning expert including performance issue identification and tuning.
• Lead incident management efforts. Coordinate database resources and activities during infrastructure incidents.
• Work with project leaders to determine DBA resource requirements for specific projects.
• Identify and communicate team operational efficiencies by process improvements and/or implementing new technologies.
• Tier 2/3 troubleshooting. When technical issues are escalated internally, you can work until resolution.
• Clearly articulate requirements, issues, project status, etc. to non-technical management personnel.
• Identify and communicate licensing, sizing, upgrades, etc. requirements to technology vendors.
• Lead change management for the team. Participate in Production Change Control meetings and give input to scheduled changes across the department
• Standard DBA tasks – installation, space management, backup & recovery, patching, upgrades, etc. in both Oracle and SQL Server environments
• Participate in 24/7 on-call rotation.
• Mentoring of junior Database Administrators.
• Develop and maintain a DBA technical roadmap.
• Accountable for hardware and/or software research and evaluation.
• Writes and maintain documentation for standard procedures.

What You'll Bring

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.

• Associates degree with 7- 10 years of experience in database support is MS SQL Server environments.

• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Ability to troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Knowledge of backups, restores, recovery models, database shrink operations, DBCC and commands.
• Experience in implementing and supporting operational automation.
• Strong knowledge of how indexes, index management, integrity checks, configuration, patching. How statistics work, how indexes are stored, how they can be created and managed effectively.
• Solid acquaintance with windows server, security delegation, SPNs, storage components.
• Documentation skills for processes and procedures.
• Microsoft Azure cloud service experience desired.
• Experience in coordinating and executing installation, configuration, patching and upgrades.
• Strong knowledge of SQL Server Database HA technologies, including AlwaysOn and Log Shipping.
• Experience with virtualization technologies in a database environment.
• Ability to handle multiple simultaneous projects with aggressive deadlines.
• Ability to troubleshoot issues using Microsoft Support and other online resources.
• Familiarity with data modeling and data mining.
• Good knowledge of Database replication technologies.
• Experienced distributed computing architectures.
• Experienced in the underlying operating systems (Windows, Linux).
• Experienced in structured Query Language.
• Good database design experience.
• Good understanding of database hardware design, including disk subsystems.
• Basic project management skills, ability to develop, scope, schedule, communicate and deliver.

Technical Skills

Strong experience in Database Administration and experience with: Experience required with all the following…

• SQL Server Database 2008R2
• SQL Server Database 2012
• SQL Server Database 2016
• SQL Server Management Studio
• SQL Server on Virtual Servers
• PowerShell scripting skills
• SQL Server Security Practices
• Knowledge of SQL Server tools (Profiler, SSIS, SSAS, SSRS, SSMS, PerfMon, DMVs, system procs)

What We Offer You

• Competitive Compensation & Benefits: Includes performance bonuses, generous paid time off, and a top-tier retirement program with 401(k) matching and additional company contributions.
• Collaborative Culture: Work alongside talented, passionate peers who value ownership and continuous learning.
• Community & Giving: Benefit from 50% charitable gift matching and paid volunteer time to support nonprofit causes
• Great Place to Work® Certified: Join a team recognized for an environment of innovation and growth.

Accessibility and Accommodations

We are committed to providing an inclusive and accessible recruitment process. If you require accommodation at any stage of the application or interview process, please let us know by contacting jmrecruiting@jminsure.com.