39021BRRequisition ID:39021BRBusiness Unit:CORJob Description:CDM Smith is seeking a Lead Database Administrator to join our global IT team. This individual will support mission-critical database systems, integrations, applications, and related infrastructure. Supports production systems and manages incidents by researching, coordinating resources, communicating with Information Technology (IT) and business staff, and resolving root causes. Collaborate with other IT teams such as business partners, network, security, cloud infrastructure, application teams and external vendors and consultants to design, integrate and implement applications and processes. Strictly enforces data integrity, data security, and data privacy by reviewing security announcements, performing periodic audit controls and applying patches. Research, install and configure database systems and related services, including hyper care. Maintains the organization's services across multiple platforms and computing environments, both on-premises and in the cloud. Monitors system health and performance to ensure high levels of performance and 24/7 availability. Provides technical expertise from service requests to large multi-year projects for application upgrades, migrations, and patch management. Independently analyze, solve, and remediate complex issues, providing permanent problem resolution and root cause reports. Implement backups, restores databases and applications, and recommends recovery models. Develops, modifies, and enhances scripts for backups, obfuscation, alerts, process improvements, routine and ad hoc reporting, and automation wherever possible. Creates and maintains operations and deployment documentation and provides knowledge transfer to team members. Updates the DBA Portal Page in Microsoft Teams. Plans, creates, participates in reviews, and executes production deployments. Reviews current processes to make sure they are still functioning properly and offers solutions on improving existing workflows.#LI-LP1#LI-REMOTEJob Title:Lead Database Administrator (Remote Work Options)Group:COREmployment Type:RegularMinimum Qualifications: Bachelor's degree. 8 years of related experience. Equivalent additional directly related experience will be considered in lieu of a degree.Domestic and/or international travel may be required. The frequency of travel is contingent on specific duties, responsibilities, and the essential functions of the position, which may vary depending on workload and project demands.Preferred Qualifications: Strong working knowledge and experience with Microsoft SQL Server including Replication, Clustering, Always On and other HA architectures; Microsoft Azure SQL Database; Microsoft Azure Synapse; Microsoft SQL Server Integration Services; Microsoft SQL Server Reporting Services; Microsoft Windows Server OS Administration, Microsoft Power Automate. Working knowledge and experience with Oracle Database v19+; Oracle E-Business Suite R12.2; Oracle Fusion Applications; Oracle Cloud Infrastructure (OCI) Administration; Quest Stat for Oracle E-Business Suite. Experience with PL/SQL Programming; Linux Shell Scripting; Linux OS Administration. Knowledge and experience with Amazon Web Services Redshift; PostgreSQL.EEO Statement:We attract the best people in the industry, supporting their efforts to learn and grow. We strive to create a challenging and progressive work environment. We provide career opportunities that span a variety of disciplines and geographic locations, with projects that our employees plan, design, build and operate as diverse as the needs of our clients. CDM Smith is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, creed, sex, pregnancy and pregnancy-related conditions, sexual orientation, gender identity, national origin, age, marital status, disability, citizenship status, genetics, protected veteran status or any other characteristics protected by applicable law.Why CDM Smith?:Check out this video and find out why our team loves to work here! (https://www.cdmsmith.com/en/Video/Meet-CDM-Smith)Join Us! CDM Smith – where amazing career journeys unfold.Imagine a place committed to offering an unmatched employee experience. Where you work on projects that are meaningful to you. Where you play an active part in shaping your career journey. Where your co-workers are invested in you and your success. Where you are encouraged and supported to do your very best and given the tools and resources to do so. Where it’s a priority that the company takes good care of you and your family.Our employees are the heart of our company. As an employer of choice, our goal is to provide a challenging, progressive and inclusive work environment which fosters personal leadership, career growth and development for every employee. We value passionate individuals who challenge the norm, deliver world-class solutions and bring diverse perspectives. Join our team, and together we will make a difference and change the world.Job Site Location:Illinois - ChicagoAgency Disclaimer:All vendors must have a signed CDM Smith Placement Agreement from the CDM Smith Recruitment Center Manager to receive payment for your placement. Verbal or written commitments from any other member of the CDM Smith staff will not be considered binding terms. All unsolicited resumes sent to CDM Smith and any resume submitted to any employee outside of CDM Smith Recruiting Center Team (RCT) will be considered property of CDM Smith. CDM Smith will not be held liable to pay a placement fee.Amount of Travel Required:5%Assignment Category:Fulltime-RegularVisa Sponsorship Available:No - We will not support sponsorship, i.e. H-1B or TN Visas for this positionSkills and Abilities: Excellent communication and analytical skills. Ability to lead small teams and manage individual and team time and tasks to deadlines, reporting on progress and escalation to management. Excellent knowledge of managing database systems, related technical stack and processes including performance management and operational control.Background Check and Drug Testing Information:CDM Smith Inc. and its divisions and subsidiaries (hereafter collectively referred to as “CDM Smith”) reserves the right to require background checks including criminal, employment, education, licensure, etc. as well as credit and motor vehicle when applicable for certain positions. In addition, CDM Smith may conduct drug testing for designated positions. Background checks are conducted after an offer of employment has been made in the United States. The timing of when background checks will be conducted on candidates for positions outside the United States will vary based on country statutory law but in no case, will the background check precede an interview. CDM Smith will conduct interviews of qualified individuals prior to requesting a criminal background check, and no job application submitted prior to such interview shall inquire into an applicant's criminal history. If this position is subject to a background check for any convictions related to its responsibilities and requirements, employment will be contingent upon successful completion of a background investigation including criminal history. Criminal history will not automatically disqualify a candidate. In addition, during employment individuals may be required by CDM Smith or a CDM Smith client to successfully complete additional background checks, including motor vehicle record as well as drug testing.Additional Compensation:All bonuses at CDM Smith are discretionary and may or may not apply to this position.Work Location Options:Fully Remote or Hybrid Work Options may be considered for successful candidate.