This job might no longer be available.

Sr Technical Lead - Database Administrator

Uttar Pradesh 201301 India

1 year ago

Job Posting Title

Summary

o 24/7 support of production database services to ensure the highest standards of availability, resilience, integrity, security and performance required by business systems
o SQL 2012, 2016/2017/2019 Installation, Good troubleshooting skills especially on Performance & tuning
o Good to have intermediate level experience in Cloud Azure, SQL hosted services
o Development and Oversight of backup strategies for the SQL Server Infrastructure
o Manage SQL Database Security
o Performs capacity planning
o Responsible for monitoring and making decision for performance tuning (high CPU, memory issues, I/O issues, indexes and their fragmentations, updating statistics, server profiler).
o Reviews, analyses, evaluates, and recommends new/existing technologies that might increase productivity, reduce down time, or improve the quality of work related to SQL server systems
o Work closely with business and IT associates, and outside vendors to effectively choose, plan, deploy and maintain system changes
o Apply Service packs, hot fixes & CUs.
o Monitor SQL Server, SQL Server Agent, Error log, Application and System logs, Database and Log growth, CPU, Memory and Disk Utilization.
o Provides the operational support and development of the Microsoft SQL Server Infrastructure (Production and Non-Production environments, which includes Database Servers, Database Services, and implementation of SQL based tools and infrastructure).
o Experience with SQL in virtual, physical and cloud-based environments.
o Must have T-SQL and SSIS skills.
o Experience in Clustering, Mirroring, Replication.
o Experience creating DTS and SSIS packages
o Experience in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
o Experience in implementing operational automation using scripts
o Experience with data warehousing a plus
o Previous experience working with large databases (at least half terabyte) is necessary.
o Provide 24x7 support of the SQL environment, including on call support
o Establish and maintain Microsoft SQL Database architecture best practices, including procedures, guides, templates, and relevant documentation
o Works closely with application development team to ensure successful deployment and performance of database applications.
o Experience working with Windows, Linux server

What You'll Do

7-9+ years’ experience in SQL Server 2012, 2016/2017, 2019 with production support experience in a multi-project environment.
Good to have intermediate level experience in Cloud - GCP/Azure.
In-depth knowledge of PowerShell, T-SQL and query tuning.
Performance and tuning skills including server configuration and tracing techniques.
Good knowledge of job scheduling, backup and monitoring tools.
Experience of working with multiple projects/tasks and supporting multiple teams within a business.
Excellent communication and customer service skills
Knowledge of SQL Server native HA (High Availability) and Disaster Recovery (DR) technologies

What We're Looking For

Bachelor’s Degree in Information Technology or related field; or an equivalent combination of education and experience sufficient to successfully perform the key accountabilities of the job required.
MS DB certification mandatory

Why Aristocrat?

Aristocrat is a world leader in gaming content and technology, and a top-tier publisher of free-to-play mobile games. We deliver great performance for our B2B customers and bring joy to the lives of the millions of people who love to play our casino and mobile games. And while we focus on fun, we never forget our responsibilities. We strive to lead the way in responsible gameplay, and to lift the bar in company governance, employee wellbeing and sustainability. We’re a diverse business united by shared values and an inspiring mission to bring joy to life through the power of play.

We aim to create an environment where individual differences are valued, and all employees have the opportunity to realize their potential. We welcome and encourage applications from all people regardless of age, gender, race, ethnicity, cultural background, disability status or LGBTQ+ identity. We offer a range of flexible working options through all.flex, our flexible hybrid work model and invite you to have a conversation with us about flexible working. EEO M/F/D/V

World Leader in Gaming Entertainment
Robust benefits package
Global career opportunities

Our Values

All about the Player
Talent Unleashed
Collective Brilliance
Good Business Good Citizen

The US based roles may require registration with the Nevada Gaming Control Board (NGCB) and/or other gaming jurisdictions in which we operate.

Create Your Profile — Game companies can contact you with their relevant job openings.

Apply