Database Administrator

Database Administrator

Bangalore, 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.

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.
- This position requires working 5 days per week including shifts (morning/afternoon/night), weekends and off-shift/on-call as needed

Required skills and qualifications
- 2-3 years of experience administering all aspects of SQL Server databases including installation, configuration, deployment, and general administration of the database engine, creating and maintaining databases and database objects (logical and physical), performance tuning, networking, and security
- Experience with virtualization including VMWare and the Microsoft Azure cloud
- Basic knowledge 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
- 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 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

Preferred skills and qualifications
- Linux operating systems (any flavor)
- Other relational databases (Oracle, MySQL, PostgreSQL, etc.)
- Non-relational databases (MongoDB, Cassandra, etc.)
- Azure SQL and SQL Managed Instance
- Other scripting languages (Bash, Python, Rust, Go, etc.)
- Microsoft DP-300 Certification

The Office:
We have an office in the Silicon Valley of India: Bangalore.
- Located adjacent to Bangalore’s new metro system
- Brand new office space boasts an open, modern vibe
- Office space provides collaboration area for casual gatherings as well as office cabins for privacy when needed
- Office has a tuck shop for quick snacks, free coffee, and vending machines
- Habba committee and monthly employee engagement activities provide opportunities for fun and celebration at work

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 opportunity/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.