[Remote] Senior Database Administrator-2868 (Remote)
Note: The job is a remote job and is open to candidates in USA. CES has 26+ years of experience in delivering Software Product Development, Quality Engineering, and Digital Transformation Consulting Services. They are seeking a highly motivated and skilled Database Reliability Engineer (DBRE) to ensure the stability, performance, and security of their extensive SQL Server database ecosystem, which supports a high-availability SaaS platform.
Responsibilities
- Guarantee all data meets our RPO (Recovery Point Objective) and RTO (Recovery Time Objective) by performing and testing backup and restoration plans
- Maintain the high reliability of our on-premise and Amazon RDS/EC2 DB environments using proven SQL Server and/or AWS HA technologies (e.g., AlwaysOn Availability Groups, Clustering)
- Enforce and maintain robust database security policies to safeguard information against unauthorized damage, modification, or disclosure
- Continuously monitor database environments to ensure optimal performance. Assist with performance and tuning efforts by analysing database performance using various tools and monitors
- Develop a strong understanding of our complex SaaS, multi-tenant, single-tenant, OLTP, and reporting database environments and their support processes within the cloud
- Actively share information and learn key skills and processes from other data team members
- Participate in the client Database On-Call Rotation
- Actively diagnose database performance problems and collaborate with the development team to provide efficient solutions and technical guidance
- Identify opportunities for process improvements and create automated solutions to streamline routine, time-consuming operational tasks
- Streamline data team procedures and contribute to overall efficiency
- Provide strategic suggestions/recommendations for design and code changes to improve application performance and end-user experience
- Tune existing SQL procedures and DB indexes to maximize efficiency
- Plan, collaborate on, and successfully complete projects with a high degree of ownership
- Mentor and train new SQL Server Database Administrators on database support procedures
- Create robust documentation for applications or processes where you are the Subject Matter Expert (SME), and actively cross-train other team members on these areas of expertise Skills
- Core DBA Skills: Proven experience with managing, maintaining, and monitoring enterprise database systems
- SQL Server Expertise: Experience implementing and supporting SQL Server 2016 through 2022
- Operating Systems: Extensive experience with Microsoft Windows and Linux Operating Systems
- T-SQL Mastery: Strong grasp of T-SQL development, stored procedures, functions, and query optimization
- High Availability (HA): Solid understanding and practical experience with SQL Server High Availability concepts (clustering, log shipping, AlwaysOn Availability Groups)
- Scalability: Understanding of SQL Server database scalability concepts (partitioning, replication, compression)
- Auditing & Reporting: Experience performing routine system audits and maintaining/reporting system performance statistics
- Troubleshooting: Strong analytical and problem-solving skills, including robust troubleshooting with a focus on preventative actions and utilizing tools like Wait Statistics
- Databases: PostgreSQL, MongoDB, MySQL
- Cloud: Amazon cloud database technologies, Cloud Automation
- Tools/Concepts: PowerShell, SSIS, Solarwinds DPA, Policy Based Management, Active Directory, VMWare, OLTP, DSS, OLAP, Data Archiving
- Methodologies: Experience with Agile Methodologies Company Overview
- CES is an information technology and business process management company. It was founded in 1996, and is headquartered in Bolingbrook, Illinois, USA, with a workforce of 1001-5000 employees. Its website is Company H1B Sponsorship
- CES has a track record of offering H1B sponsorships, with 14 in 2025, 10 in 2024, 7 in 2023, 13 in 2022, 11 in 2021, 15 in 2020. Please note that this does not guarantee sponsorship for this specific role. Apply tot his job
Apply tot his job Apply To this Job