SQL DBA - DLS Solutions
Princeton, NJ
About the Job
SQL DBA
Location: Princeton, NJ
3 days on-site, 2 days remote
Long term Contract position
We are looking for an individual with 3-5 yrs experience
SUMMARY
The SQL DBA is responsible for the implementation, configuration, maintenance, and performance of critical SQL Server RDBMS systems to ensure the availability and consistent performance of our corporate applications. This position requires solid technical skills, as well as excellent interpersonal and communication skills. The SQL DBA is responsible for the development and sustainment of the SQL Server Eco-System, ensuring its operational readiness (security, health, and performance), executing data loads, and performing data modeling in support of multiple development teams. The incumbent will also develop and manage a robust data warehouse to support a suite of program management tools.
PRIMARY RESPONSIBILITIES
- Manage SQL Server databases through multiple product lifecycle environments, from development to mission-critical production systems.
- Configure and maintain database servers and processes, including monitoring of system health, to ensure optimal performance, availability, and security.
- Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.
- Refine and automate regular processes, track issues, and document changes.
- Assist developers with complex query tuning and schema refinement.
- Perform scheduled maintenance and support release deployment activities.
- Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.
- Install and configure new Microsoft SQL Server instances, including Always On availability groups and failover clustering.
- Highly skilled at database design, installations, and conversions.
- Document and manage database backup and recovery procedures, access security and database integrity, physical data storage design and data storage management.
- Engage in ongoing process improvement.
- Other duties as assigned.
KNOWLEDGE AND SKILL REQUIREMENTS/COMPETENCIES
- 3+ years MS SQL Server Administration experience required.
- 3+ years w/ Development and integration of SQL database services in an enterprise environment.
- 3+ years working w/large databases (1 TB+).
- 3+ years working in a clustered Windows environment.
- 3+ years w/ SQL Server Integration Services (SSIS).
- 3+ years w/ SQL Server Reporting Services (SSRS).
- MCTS, MCITP, and/or MVP certifications a plus.
- A working knowledge of Salesforce/MuleSoft/Snowflake would be a plus.
- Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
- Experience with backups, restores and recovery models.
- Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server.
- Excellent written and verbal communication.
- Flexible, collaborator, “get-it-done” personality.
- Ability to organize and plan work independently.
- Ability to work in a rapidly changing environment.
- Ability to multi-task and context-switch effectively between different activities and teams
- Experienced in Database Performance, Maintenance and Development to perform the following:
- Database management including backups, recovery, and maintenance.
- Database management for export, import and mass data loads.
- Analyzes and generation of all tables and index statistics.
- Monitoring and resolving data lock issues.
- Check all statistics related to memory, locks, I/O, database response time, wait events, top sessions, and background processes.
- Create indexes to achieve critical dataset response time for time sensitive reports.
- Install SQL Server service packs and updates.
- Configure and manage SQL Security settings.
- Manage database backup & recovery & DR planning in collaboration with IT manager and System Engineer.
- Create, modify, and optimize SQL Server Agent jobs and maintenance plans.
- Proactively monitor SQL Server maintenance tasks, troubleshoot failed jobs, and resolve issues in a timely manner. Insight
- Troubleshoot application slowness and performance issues.
- Perform SQL Server integration with enterprise applications.
- Experienced in Database Design and Development to perform the following:
- New projects database design utilizing
- SQL Stored procedures development, compilation and debugging.
Source : DLS Solutions