About the job Senior SQL Server DBA ConsultantJob purpose:This position requires a highly competent, highly motivated, and driven individual who is able to work well on their own and within the team, with limited supervision, and who actively seeks ways of adding value to the business in their role as Senior DBA. Primary responsibilities include database software installation and upgrades, database requirements analysis and design, database creation, database monitoring, and tuning, database backup and recovery, and maintenance of existing database support scripts and related processes. Cloud experience (preferably AWS)Bachelors Degree or Diploma in Computer Science or related fieldMust have 7+ years of experienceMust be able to work independently with little supervision.Required to have Cloud experience preferably in AWS.Must possess excellent communication skills, including writing and presenting technical reports, presentations, and general correspondence.Experience with MS SQL Server - Clustered SQL Servers, replication, database replicationResponsibilities:Database Software Installation and Upgrades. Identify server hardware, software and configurations necessary for the various SQL versionsDevelop new processes, leveraging new technology, to streamline the process of building new database serversDatabase Requirements Analysis and DesignEnforcement of database standardsWork with application development teams to design, and review designs for new databases, or changes to existing databasesAssess and identify database server resource requirements based on new application and customer requirementsPeriodically assess and refine database standards based on new technologies and business directionDatabase Monitoring and TuningDevelop and improve procedures for automated monitoring of database availability and performanceReview performance stats and recommend changes for tuning database, server, storage configurations, and applicationsDatabase Backup and RecoveryParticipate in backup audits, ensuring all databases and associated logs are being backed-upPeriodically conduct test database restores to validate backup integrity and refresh skillsGather requirements and make recommendations for application backup and recoveryImplement new backup and recovery processes that leverage new techniques and technologyDatabase Problem Research and ResolutionAssume ownership of database-related problems; pursuing short and long-term problem resolution and root cause analysisWork with vendors and internal support representatives to gather information, and determine and implement resolutions. Coordinate interaction with vendors in critical database problem situations
#J-18808-Ljbffr