Title: Lead DBA (MSSQL) Location: Philadelphia, PA, Alexandria, VA, USA Full time job requisition id JREQ135276 Job Description: We are seeking an experienced MSSQL Developer (DBAEngineer)to join a small, highly technical team of SQL Server engineersglobally. This team focuses on designing, developing,optimizing, and maintaining MSSQLbased data platforms across all environments (AWS, Azure, On-Prem). This role requires anMSSQLengineer/developer whocanoperatewith a high degree of autonomy whilemaintainingstrong technical and architectural alignment with global stakeholders. This is a hands-on technical role that combines deep systemlevel understanding, strong SQL Server developmentexpertise, and direct contribution to the design, performance, and reliability of our MSSQL platform.Knowledge of PostgreSQL and MySQL is considered a strong asset. About You – Experience, education, skills, and accomplishments - 7 years minimum of experience as a MSSQL RDBMS DBA and SQL Developer - 7 years of experience of physical and logical MSSQL Server and database design knowledge - At least 7 years of experience with strong SQL DB architecture logical and physical understanding. - At least 7 years of experience in database performance tuning and capacity planning. - At least 7 years of experience working with AWS cloud infrastructure. - Must be a US Citizen or Green Card holder who has an active Public Trust Clearance It would be great if you also had... - Ability to perform both MSSQL and operating system performance monitoring and the necessary adjustments. - Other DB engines like Oracle Server, MySQL and Postgres databases are a plus. - A good knowledge of the operating systems - Experience/Understanding with DevOps and automation tools and basic knowledge about CloudOps processes - Monitoring tools and alerting like Data Dog and Pager Duty - Excellent knowledge of MSSQL backup and recovery scenarios. - Excellent skills in all Microsoft tools: SSMS, SSRS, SSIS - Excellent knowledge of MSSQL security management. What will you be doing in this role? - Creates and maintains all databases required for development, testing, education, and production usage. - Performs the capacity planning required to create and maintain the databases. The DBA works closely with system administration. - Formulate and execute remediation plans where existing Database deployments fall short of industry and company standards. - Assist in troubleshooting efforts when data integrity or database performance is suspected is a possible cause of service issues. - Performs ongoing tuning of the database instances. - Install new versions of the MSSQL and its tools and any other tools that access the SQL database. - Plans and implements backup and recovery of the MSSQL database. - Advise development teams on appropriate database server deployment and configuration. Implements and enforces security for all the SQL Databases. - Performs database re-organizations as required to assist performance and ensure maximum uptime of the database. - Support service delivery and development teams by refreshing non-production database environments. - Test patches to ensure compatibility with the database environment and participate in regular patching cycle. - Enforces and maintains database constraints to ensure integrity of the database. - Administers all database objects, including tables, clusters, indexes, views, sequences, packages, and procedures. - Assists with impact analysis of any changes made to the database objects. - Monitor Database alerts and respond to issues and errors. - Assess, develop, and improve database High Availability\Disaster Recovery strategy Implement maintenance plans and monitoring to ensure Database instances are running optimally and making best use of computing resources. - Contribute to the overall strategy for the Enterprise Solutions SQL Server estate supporting internal applications. - Supporting developers to ensure their applications query the DBs in the most efficient, possible way. - Assisting with your expertise to new projects in order to define the best technologies and approaches to use from the DBA perspective. - Assisting to resolve day to day incidents with our assets. About the Team This is an amazing opportunity to join a multidisciplinary team who works on a wide range of technologies. The team consists of 8 DBA colleagues across 3 different time zones (EMEA, US, India). Hours of Work - Full time, permanent position - Hybrid working schedule on-site 2-3 days/week - Must live within a commutable distance to one of our US office locations – Philadelphia, PA highly preferred. Will also consider Alexandria, VA. At Clarivate, we are committed to providing equal employment opportunities for all qualified persons with respect to hiring, compensation, promotion, training, and other terms, conditions, and privileges of employment. We comply with applicable laws and regulations governing non-discrimination in all locations.

• Manage the full database lifecycle: initial installation and configuration of database technologies, deployment of engineered system design solutions, daily operations, administration, upgrades, and management of database technologies • Provide high-end technical DBA support within a variety of Operating Environments (OE) while also supporting/assisting software development and operational teams with database definition, structure, long-range requirements, operational guidelines, and security/integrity controls according to industry best practices • Propose and implement enhancements to improve performance and reliability within the supported IT environments • Install, configure, upgrade, and patch Oracle EBS environments including both database and application tiers • Manage EBS concurrent managers, workflows, and patch application • Troubleshoot and resolve issues across database and application tiers • Provide subject matter expertise in performance tuning and administration. Analyze and tune SQL and Oracle EBS • Perform DDL code reviews and application code reviews for functionality related to a database • Independently analyze, solve, and correct issues in real time, providing problem resolution • Work closely with L1/L2/L3 support teams to proactively identify and resolve issues • Participate in 24x7 on-call rotation

With a career at HMSHost, you really benefit! We Offer - Health, dental and vision insurance - Generous paid time off (vacation, flex or sick) - *401(k) retirement plan with company match - *Company paid life insurance - *Tuition reimbursement - Employee assistance program - Training and exciting career growth opportunities - Referral program – refer a friend and earn a bonus *Benefits may vary by position so ask your recruiter for details. Airport Location: Corporate-Growth Region Advertised Compensation: $90,800.00 to $110,000.00 Purpose: The Sr. Database Specialist is responsible for developing, testing, implementing, supporting, and coordinating changes to Point of Sale (POS) databases, and performing all other responsibilities as directed by the business or as assigned by management. Essential Functions: - Ensures POS is programmed to meet financial and operational controls - Maintains POS database and develops new scripts - Designs, codes, debugs, and tests program modules that meet design specifications and all development standards - Diagnoses, resolves, and documents POS system issues - Develops and supports integrations, conversions, reports, workflow, and custom development of POS systems - Troubleshoots business problems and high-level systems issues on a daily basis working with functional and technical resources - Manages POS database portion of projects and project scheduling commitments - Designs database structures for new implementations - Maintains overall database structures and standards - Acts as liaison with third party vendors and other database and IT resources Reporting Relationship: The Senior Database Specialist reports into the Senior Manager Master Data North America Minimum Qualifications, Knowledge, Skills, and Work Environment: - Education and Experience: The combination of education and professional experience must exceed 5 years: - In a technical role: Requires 5 years of experience engaged in developing and delivering database programs - A bachelor’s degree in a program related to the functional area can count for 3 of the 5-year requirement - In the industry: 3-5 years of Hospitality, F&B and/or Retail experience - Specialized Skillset/Competencies/Traits - - Excellent organizational skills, with superior problem resolution and analytical skills - Business acumen and also has the mindset required to understand the long-term implications of database planning and to advance the organizations goals - Demonstrated history of understanding the needs of the business, stakeholders, the employee population and individual circumstances - Demonstrated history of creating and maintaining positive work environments - Location: This is a remote position that requires ability to travel as requested not more than 10% of the time Avolta, including Dufry, HMSHost Corporation, Hudson, and affiliates (“the Company”), is an equal opportunity employer. It is the Company’s policy to ensure equal employment opportunity in all aspects of employment and to comply with anti-discrimination laws and regulations. The Company prohibits discrimination and harassment of any type and provides equal opportunities to applicants and team members without regard to actual or perceived race, color, creed, age, religion, sex or gender (including pregnancy, childbirth, related medical conditions and lactation), gender identity or gender expression (including transgender status), sexual orientation, national origin, disability, military service and veteran status, ancestry, citizenship status, marital status, protected medical condition as defined by applicable state or local law, genetic information, or any other basis protected by applicable federal, state or local laws and ordinances (referred to as “protected characteristics”).

Responsibilities Peraton is seeking a Database Administrator (Journeyman) to support the MODES III program supporting Military Community and Family Policy (MC&FP). In this role, the selected candidate will support database administration, routine maintenance, monitoring, and operational tasks for the program databases and data feeds under senior DBA guidance, ensuring stable operations for development, test, and production environments. This position is remote and requires an active Secret clearance. JOB DESCRIPTION - Support database administration, routine maintenance, monitoring, and operational tasks for MODES III databases and data feeds under senior DBA guidance, ensuring stable operations for development, test, and production environments. - Perform routine DBA tasks: manage user accounts/roles, run backups and restores, apply patches under change control, monitor health (CPU/memory/disk), and resolve common incidents. - Support performance tuning tasks: assist in query tuning, add indexes, collect statistics, and implement recommended quick fixes to improve dashboard and application responsiveness. - Support ETL/ingestion operations: coordinate with Data Engineers to run and validate ETL jobs, troubleshoot data load issues, and ensure data quality for dashboards. - Implement basic security controls: enforce least privilege roles, assist with audit logging, and participate in vulnerability scan remediation activities (IAVA/ACAS) per CCM/SCM direction. - Maintain documentation: update runbooks, backup/recovery procedures, and DB change logs; assist with RMF evidence collection as requested. - Familiar with: PostgreSQL, MySQL, Amazon RDS management, backups/snapshot validation, basic RMAN/SQL Server backup, replication monitoring, run simple Terraform/CloudFormation/IaC modules, write and optimize SQL queries, set up CloudWatch metrics/dashboards, perform restores in dev/test, assist DB schema migrations and ETL verification. Qualifications REQUIRED QUALIFICATIONS - Active Secret clearance required. - Expereince / Education: 5 years relevant experience BS/BA degree or 3 years with MS/MA or 1 year with PhD or 9 years w/o a degree or 7 years with AS/A - Certifications: This role requires a demonstration of capability within the Cyberspace IT workforce. Successful applicants must satisfy Foundational Qualification standards via an approved industry certification (e.g., A+ or Network+) or documented equivalent military/educational training as defined in the DoD 8140 Qualification Matrix. PREFERRED QUALIFICATIONS - Eligible for Top Secret/SCI clearance. - Familiarity with NIST RMF, ATO processes, and DoD security compliance frameworks. - Experience with cloud-native database services such as Amazon RDS, Aurora, or DynamoDB. - CompTIA Security+ Worklocation: remote with ability to travel if required Peraton Overview Peraton is a next-generation national security company that drives missions of consequence spanning the globe and extending to the farthest reaches of the galaxy. As the world’s leading mission capability integrator and transformative enterprise IT provider, we deliver trusted, highly differentiated solutions and technologies to protect our nation and allies. Peraton operates at the critical nexus between traditional and nontraditional threats across all domains: land, sea, space, air, and cyberspace. The company serves as a valued partner to essential government agencies and supports every branch of the U.S. armed forces. Each day, our employees do the can’t be done by solving the most daunting challenges facing our customers. Visit peraton.com to learn how we’re keeping people around the world safe and secure. Target Salary Range $66,000 - $106,000. This represents the typical salary range for this position. Salary is determined by various factors, including but not limited to, the scope and responsibilities of the position, the individual’s experience, education, knowledge, skills, and competencies, as well as geographic location and business and contract considerations. Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay. EEO EEO: Equal opportunity employer, including disability and protected veterans, or other characteristics protected by law.