Senior Database Administrator II Bangalore or Chennai India The Opportunity Anthology offers the largest EdTech ecosystem on a global scale supporting over 150 million users in 80 countries Our mission is to provide dynamic data-informed experiences to the global education community so that learners and educators can achieve their goals We believe in the power of a truly diverse and inclusive workforce As we expand globally we are committed to making diversity inclusion and belonging a foundational part of not only our hiring practices but who we are as a company For more information about Anthology and our career opportunities please visit www anthology com Anthology is looking for a qualified candidate to join our Cloud Services Database Administration team The Cloud Services team is responsible for delivering high-availability Software-as-a-Service SaaS solutions to our customers The team supports this mission by delivering highly available secure and performant databases for our applications The candidate will work primarily as a Senior SQL Server and PostgreSQL database administrator in a mixture of hosting environments including self-hosted physical and virtual machines as well as cloud-based infrastructure on Azure and Amazon Web Services The successful candidate will have experience across all the normal database administration activities in both hosted and cloud environments Ideal candidates will also have experience in advanced areas like replication high availability reporting and scripting skills Primary responsibilities will include Deploying new database systems and ancillary services including design layout configuration and tuning Monitoring existing database systems for availability performance and scalability Maintaining database security ensuring appropriate levels of access are maintained backups are being taken according to established guidelines and that backups are periodically tested to ensure recoverability Troubleshooting issues impacting the availability stability and performance of our databases at scale This includes not only the database engine but the operating system it is running on and the SQL it is running as well Understanding the query profiling infrastructure execution statistics and execution plans Analyzing understanding and editing database objects code and scripts Documenting databases database processes and procedures as well as changes and incidents Collaborating with other database administrators as well as internal teams and external clients on issues projects initiatives etc Developing and maintaining an in-depth understanding of the application infrastructure functionality and overall systems design as it relates to the databases This role requires the willingness to work 5 days per week including shifts morning afternoon night weekends and off-shift on-call as needed The Candidate Required skills qualifications At least 7 years of experience administering all aspects of SQL Server and PostgreSQL databases including installation configuration deployment and general administration of the database engine creating and maintaining databases and database objects logical and physical performance tuning optimization networking and security Experience with virtualization including Microsoft Azure Cloud and Amazon Web Services Basic knowledge of the Windows operating system and how it interacts with the database Database scripting skills Ability to read analyze and write Transact-SQL System scripting skills Ability to read analyze and write batch files and PowerShell scripts Deep expertise in troubleshooting slow-running queries optimizing indexes analyzing execution plans and improving database performance at scale Provide Backup and Recovery Strong understanding of database security models encryption and auditing practices to meet organizational and compliance standards Experience with SQL Server replication types and the services that support them Change Tracking Change Data Capture etc Experience designing configuring and testing database standard and high availability models Experience with reporting services including SQL Server Reporting Service SSRS Analysis Service and PowerBI Ability to participate in code walkthroughs and review database migrations Ability to lead DB modernization projects mentor junior DBAs engage with development teams for schema reviews and work closely with cloud infrastructure teams to ensure performance and scalability Ability to review planned changes to database objects with an eye towards maintaining data integrity implementation of primary keys necessary foreign-key constraints etc performance indexes index types partitioning etc and storage utilization and growth Fluency in written and spoken English Preferred skills and qualifications Azure SQL and SQL Managed Instance Windows and Linux operating systems any flavor Other relational databases Oracle MySQL PostgreSQL etc Non-relational databases MongoDB Cassandra etc Other scripting languages Bash Python Rust Go etc Microsoft DP-300 Certification This job description is not designed to contain a comprehensive listing of activities duties or responsibilities that are required Nothing in this job description restricts management s right to assign or reassign duties and responsibilities at any time Anthology is an equal employment prospect affirmative action employer and considers qualified applicants for employment without regard to race gender age color religion national origin marital status disability sexual orientation gender identity expression protected military veteran status or any other legally protected factor

📌 Senior Database Administrator Ii (Karnataka)
🏢 Important Business
📍 Karnataka