Intermediate Database Administrator

The Suitable DBA Candidate for this role will be responsible for the following:

• Design and Build databases from business requirements
• Develop innovation, strategies, processes, and best practices
• Work with development team on database design to meet business requirements
• Build and Configure SQL Server
• Develop SQL Server Backup and Recovery solution
• SQL Server Database configuration management (Memory, CPU, storage)
• SQL Server Performance Tuning
• Create SQL Server Maintenance plans
• Create and maintain SQL Server Build documentation
• Create and maintain SQL Server maintenance and sustainment documentation
• Create escalation process and documentation
• Manage SQL Server operations for all Client-Based Application in all environments
• Create and maintain SQL Server reporting – Daily, Health, and Exception requirements
• Installing, configuration and upgrading of database servers
• Planning storage requirements for the database system
• Modifying the database structure, as necessary, from information given by application developers
• Reviewing T-SQL code done by developers and proposes improvements
• Reviewing system and programming designs to ensure efficient use of database resources
• Controlling and monitoring user access to the database
• Monitoring and optimizing the performance of the database
• Backing up and restoring databases
• Contacting database vendor for technical support
• Developing and testing database backup procedures
• Identifying improvements to existing databases by determining users' information requirements and system performance and functional requirements
• Performing daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups
• Writing complex scripts for data manipulation and management as well as report generation
• Following all established procedures

Mandatory Experience:

• 5+ years SQL Server DBA skills on Windows platform
• Expertise with building HA solutions (AlwaysOn)
• Demonstrated work experience with application development and support