Senior Database Administrator
hace 21 días
Washington
Job DescriptionDescription: Onsite in Washington, DC Our client is a premier technology integrator delivering solutions across technical, engineering, intelligence, and enterprise IT markets with a global workforce. The organization designs, develops, and sustains offerings that empower diplomatic missions, support warfighter requirements, and advance exploration from sea to space. It holds leadership positions in supply chain, hardware integration, and global network integration, and supports programs of national importance with a commitment to ethical performance and integrity. Due to federal security clearance requirements, applicant must be a United States Citizen or Permanent Resident.Due to federal security clearance requirements, applicant must be a United States Citizen or Permanent Resident with an active Public Trust clearance.This is a contract to hire opportunity. Applicants must be willing and able to work on a w2 basis and convert to FTE following contract duration. For our w2 consultants, we offer a great benefits package that includes Medical, Dental, and Vision benefits, 401k with company matching, and life insurance. Rate: $55.00 to $62.00/hr. w2 Responsibilities: Responsibilities • Work full time onsite at DOT Headquarters in Washington, DC., • Drive, standardize, and manage the Unified Configuration Management Database., • Install, configure, and manage Microsoft SQL Server instances and tools including SSMS, SSRS, SSIS, and SSAS., • Set up and maintain new databases, servers, and supporting infrastructure., • Administer SQL Server clustering, Always On Availability Groups, replication, mirroring, and log shipping., • Monitor and maintain database performance, integrity, availability, and security., • Perform routine maintenance such as index optimization, statistics updates, and database consistency checks., • Plan and execute database upgrades, patching, and migrations., • Troubleshoot database errors, performance bottlenecks, deadlocks, and availability issues., • Analyze SQL execution plans and optimize queries for performance and scalability., • Monitor system performance using SQL Profiler, Extended Events, and Performance Monitor., • Manage database users, roles, and permissions following least‑privilege principles., • Audit database activity and maintain logging and change tracking., • Maintain detailed documentation of configurations, architecture, and changes., • Hands‑on experience working in Google Cloud Platform administering database workloads., • Strong experience administering SQL Server and Oracle, including installation, configuration, performance tuning, and maintenance., • Proficiency with SQL Server clustering and Always On Availability Groups., • Experience with on‑premises to Azure database migrations., • Experience managing SQL Server versions 2012 through 2022., • Experience with Oracle RAC, Oracle Enterprise Manager, RMAN backups, and Oracle Data Guard, including RAC on Windows., • Proficiency in Linux shell scripting., • Experience supporting AWS database environments including RDS and EC2‑based databases., • Ability to troubleshoot performance issues, analyze execution plans, and optimize workloads., • Experience implementing database security solutions including Transparent Data Encryption., • Experience with SQL STIG and Oracle STIG compliance., • Knowledge of AWS cloud concepts for DBA operations., • Experience conducting disaster recovery testing and providing on‑call production support., • Experience supporting mission‑critical 24x7 production environments (preferred)., • Experience deploying and managing SQL Server on VMware, Azure IaaS/PaaS, and on‑premises platforms (preferred)., • Experience with Azure SQL Managed Instance and Azure SQL Database (preferred)., • Experience facilitating migrations, upgrades, backups, and restores (preferred)., • Hands‑on experience administering SQL Server access and troubleshooting Always On issues (preferred)., • Experience with mirroring, log shipping, and transactional replication (preferred)., • Experience with proactive monitoring, automated health checks, index maintenance, and alerting (preferred)., • Experience configuring Database Mail, SQL job alerts, and SSRS (preferred)., • Experience installing Oracle software, applying quarterly patches, and authoring RCA documentation (preferred)., • Experience testing DR solutions and participating in DBA on‑call rotation (preferred)., • Oracle certification., • Microsoft SQL Server certification., • Google Cloud certification related to database administration (preferred). W2 employees of Eliassen Group who are regularly scheduled to work 30 or more hours per week are eligible for the following benefits: medical (choice of 3 plans), dental, vision, pre-tax accounts, other voluntary benefits including life and disability insurance, 401(k) with match, and sick time if required by law in the worked-in state/locality. Please be advised- If anyone reaches out to you about an open position connected with Eliassen Group, please confirm that they have an Eliassen.com email address and never provide personal or financial information to anyone who is not clearly associated with Eliassen Group. If you have any indication of fraudulent activity, please contact Eliassen Group: Eliassen Group is a leading strategic consulting company for human-powered solutions. For over 30 years, Eliassen has helped thousands of companies reach further and achieve more with their technology solutions, financial, risk & compliance, and advisory solutions, and clinical solutions. With offices from coast to coast and throughout Europe, Eliassen provides a local community presence, balanced with international reach. Eliassen Group strives to positively impact the lives of their employees, clients, consultants, and the communities in which they operate. Eliassen Group is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, pregnancy, sexual orientation, gender identity, national origin, age, protected veteran status, or disability status. Don’t miss out on our referral program! If we hire a candidate that you refer us to then you can be eligible for a $1,000 referral check!