Description Position OverviewAs a Database Administrator, you will help support the mission of the department by providing 24/7 support coverage for all corporate databases through ensuring the availability, integrity, accessibility and performance of databases. You will also be responsible for the development of standards and procedures for all DBA functions, and you will document standard operating procedures.
Key ResponsibilitiesTo perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
- Lead a team of DBA's in a multi-site environment
- Directs and mentor Database Analysts
- Drives day to day operations and work plan allocation/management
- Conduct periodic reviews with teams
- Weekly and monthly status reports to higher management
- Participate in business meetings with various stake holders
- Take corrective actions based on surveys and incidences
- Effort estimation/reviews on need basis for new projects and support tickets
- Ensures problem resolution by initializing and tracking problem assignments and initiates escalation as appropriate to the next level of support personnel or vendors
- Develops strategic and tactical plans for developing and maintaining corporate databases
- Develops baseline and system models to monitor DBMS and processing performance
- Coordinates enhancements and upgrades with other IT groups
- Develops capacity planning standards, monitors capacity metrics and balances present and future capacity requirements
- Keeps abreast of latest technologies and trends and makes recommendations for incorporation when appropriate
- Conduct regular Performance Tuning and Query Optimization using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools
- Troubleshoot and resolve database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. along with detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention problems
- Implement operational automation
- Documents database processes and procedures (such as creating KBs, runbooks, topology, etc.)
- Conduct SQL Development - ability to write and troubleshoot SQL Code (stored procs, functions, tables, views, triggers, indexes, constraints and other scripting languages)
The requirements listed below are representative of the knowledge, skill, and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
We are seeking candidates with the following experience and skills:- 5 + years required of experience in application systems development utilizing Microsoft SQL Server and Oracle DBMS
- 10+ years required of experience as a DBA
- Strong verbal and written communication skills and proven problem- solving skills
- Proven problem-solving skills are required
- The ability to organize work effectively in high pressure and stressful situations
Technology Focus & Requirements Competent in reporting, forecasting, capacity planning, and implementing database solutions across multiple platforms
- Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication
- 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
- Expert experience in implementing operational automation
- Knowledge of SQL Server tools: Profiler, DTA, SSMS, SAC, SSCM, PerfMon, DMVs, system sprocs including the ability to analyze outputs
- Knowledge of 3rd party DBA tools and applications
- Working knowledge with windows server, security delegation, SPNs, storage components
Education: BS in Computer Science, IT, or a related field required
Certifications MCDBA certification, or equivalent
While we're committed to providing top-tier solutions, we're just as committed to supporting our own team. Our employees enjoy a variety of comprehensive benefits, including medical/dental/vision coverage, life insurance, a 401(k) plan with matching provision, paid time off, and much more.
Zones offers a comprehensive Benefits package While we're committed to providing top-tier solutions, we're just as committed to supporting our own team. Our employees enjoy a variety of comprehensive benefits, including medical/dental/vision coverage, life insurance, a 401(k) plan with matching provision, paid time off, and much more.
