SQL Server DBA Lead / ArchitectOur client is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, our client brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries.Location: Marysville, OHThe SQL Server DBA provides a technical role in maintaining the operational stability and security of AHM's SQL Server database environment in a cost effective manner.
Additional responsibilities include providing DBA resources for database development projects funded by the application teams, acting as a liaison between the SQL Server database team and application teams, ensuring that all project deliverables by the DBA team are completed within schedule and budget. The SQL Server DBA also works closely with Data Architecture team in understanding project requirements leading to the design, build, and implementation of SQL Server databases.Daily Tasks PerformedProject Development SupportMeet with application teams to understand requirements and recommend high-level direction and approach to upcoming projectsInstall and configure SQL Server instances on servers ensuring proper settings and options are chosen based on the organization’s requirementsFine-tuning database systems to enhance performance, scalability, and reliability. This includes monitoring and optimizing database query performance, indexing, and database cachingCollaborate with developers and stakeholders to design and implement database schemas, tables, indexes, and relationshipsAttend ARB meetings to understand the new project requirements as related to database design, build, and implementation of SQL Server database applicationsManage other SQL Server DBA resources to ensure that their availability is aligned with project schedules, supply vs demandEnsure that all DBA deliverablesTuning, Monitoring, and PatchingMonitor database performance using built-in tools and third-party solutions.
Identify and resolve performance bottlenecks through query optimization, index tuning, and configuration adjustmentsConfigure and utilize monitoring tools to track database health, performance metrics, and security events. Set up alerts to notify administrators of potential issuesInter-Intra Organizational CommunicationMust understand and implement organizational policies and procedures related to the administration of the SQL Server database environmentConduct regularly scheduled meetings with team manager to understand Business Plans and Organization QCD metricsProvide Status reports to team manager Budget/finance status, project status, etcBuild and maintain good relations with other teams by fostering open communication between the application and database teamsTrack job/process failures Sev12 and conduct appropriate PDCA associated to all failures and 4Block analysis documentation and presentationTrack portfolio growth including space management, database counts, application counts, etcBackup and Recovery and DRDevelop and implement backup and recovery strategies to safeguard data against loss or corruption. Regularly test backup and recovery proceduresImplement high availability solutions such as database mirroring, clustering, or AlwaysOn Availability GroupsDevelop and test disaster recovery plansSecurity and Compliance of the SQL Server database environmentConduct periodic access reviews on a monthly basisFollow and enforce defined database access policiesMaintain daily backup metrics ensuring all SOX database backups are monitored according to policies and proceduresDevelop and maintain SOX documentation, security access, backup procedures, and target ZERO SOX deficienciesParticipate in the implementation of PII initiatives as defined by Ent Architecture and application teamsImplement and maintain security measures to protect sensitive data and ensure compliance with regulatory requirements such as General Data Protection Regulation (GDPR)What will this person be working onEnsure that all DBA deliverables to the projects are performed within project schedule and budgetDevelop and implement backup and recovery strategies to safeguard data against loss or corruption.
Regularly test backup and recovery proceduresImplement high availability solutions such as database mirroring, clustering, or AlwaysOn Availability GroupsPosition Success Criteria Desired WANTSBachelor’s or Master’s degree in Information Systems, IS, Computer Science, software engineering, information technology, and/or equivalent industry experienceMicrosoft SQL Server Database Administrator experienceExperience in working large scale projectsShould have knowledge of cloud computing concepts, virtualization, and infrastructure-as-a-service (IaaS) platformsEXPERIENCE IN SOX RELATED REQUESTSOther Job-Specific SkillsStrong technical knowledge of SQL Server database administration, architecture, design, data analysisSkillsMandatory Skills: MS SQL Server, MS SQL DB AdministrationDisclaimer: E-Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state, and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply.