Sr. SQL Database Administrator

Job Description

We have a position for a Sr. SQL Database Administrator with one of our clients in Remote for an initial contract duration of 6 months. No third party candidates considered for this position.

Education: Bachelors degree in computer science or equivalent work experience.

Experience:

• A minimum of 5 years of experience working with Microsoft SQL Server is required.
• A minimum of 5 years of experience as a Microsoft SQL Server DBA is required.
• A minimum of 2 years of experience working with SSIS & SSRS is required.
• Experience working in a high availability environment.

Summary (scope and purpose): To install, optimize and maintain database systems and support software. Monitor and maintain performance of database systems which also includes backups, restore and disaster recovery. Provide technical assistance to IT staff and users of IT systems and assure compliance to departmental procedures.

Professional Qualifications

• Strong English communication skills (i.e. writing, documenting, speaking, & presenting)
• Strong problem investigation and resolution skills
• Excellent team player
• Self-motivated and self-directed.

Preferred Skills

• Experience with Spotlight and or Solarwinds Database Performance Analyzer
• Experience with database partitioning, archiving and purging
• Knowledge of Microsoft Azure would be an advantage
• Minimum of 2 years of experience as a developer using Microsoft SQL, SSIS, and or SSRS
• Certification as a Database Administrator in Microsoft SQL Server is a plus
• Knowledge of MS SQL always-on feature
• Knowledge of SQL Server 2012, 2014, 2016, 2017, or 2019
• Project planning and management and very high attention to details
• Microsoft training and certification will be considered a strong asset

Duties and Responsibilities:

• Monitor, maintain, and help to improve the performance of database systems - which includes database backups, restores, and disaster recovery.
• Define the database logical and physical design and the security, back-up, and recovery specifications.
• Optimize database indexes, queries, stored procedures, and reports.
• Ensure compliance to audit and departmental policies and procedures.
• Provide technical assistance to the IT staff and users of IT systems.
• Work closely with the project managers, business analysts, software developers, quality assurance engineers and management during all phases of the Software Development Life Cycle.
• Design and build normalized and denormalized database solutions using best practices.
• Implement new technologies.
• Work on multiple concurrent deadline-driven projects.
• On-call responsibilities required.
• Participate in technical evaluation of new computer hardware and software and make recommendations to address business solutions.
• Assist in development of new application systems and database changes.
• Collect system historical data for trend and projection usage analysis.
• Administer data archiving process ensuring compliance with policy.
• Assist in problem analysis and resolution as required.
• Perform administrative duties as to formal reporting of activity, progress and performance.
• Responsible for the provision of detailed analysis and reporting for various database activities
• Develop, implement and manage policies and procedures ensuring the integrity and security of the databases. These policies will be review and modify by management before implementing.
• Responsible for installing database binaries or upgrading an existing database server
• Responsible for planning for backup and recovery of the databases in coordination with the Technical Support & Operations department
• Establishing standards and schedules for database backups
• Developing recovery procedures for each database
• Making sure that the backup schedules meet the recovery requirements
• Monitoring the health of the database server which includes:
• The server is running with optimal performance.
• The error log or event log is monitored for database errors.
• Setup database alerts/notifications.
• Responsible for having databases routine maintenance performed and the overall system has periodic maintenance performed by the system administrator.
• Responsible for maintaining the proper use of storage which includes monitoring disk space requirements
• Responsible for setting up and scheduling various events
• Develop, Perform and manage database disaster recovery procedures.
• Help developers to optimize database/applications coding (queries, stored procedures, & etc.)
• Where possible, help developers tune queries, assigning proper indexes, and aiding developers in the creation of triggers and stored procedures