Job Search
Senior Database Administrator IRC174057
Job: | IRC174057 |
Location: | India - Noida |
Designation: | Consultant |
Experience: | 5-10 years |
Function: | Engineering |
Skills: | Amazon Relational Database Service (RDS), AWS, MySQL, PostgreSQL, Power Shell, Python, SQL Server, T-SQL |
Description:
As a Senior Database Administrator, you will provide technical vision and leadership related to RDS (SQL Server, MySQL, PostgreSQL, etc.) Operations on the CloudOps team. You will be responsible for maintaining and nurturing clients’ database environments.
Requirements:
15 or more years of production experience in RDS (SQL Server, PostgreSQL) database
administration in high volume Multi-Terabyte OLTP environments
5 or more years of experience working within High Availability (HA) SQL Server
environments
5 or more years of experience optimizing T-SQL or pgSQL queries
Experience developing/modeling high-performing databases (both OLTP and OLAP)
Working knowledge of Microsoft SQL servers (2014, 2017, and 2019 versions)
Working knowledge of PostgreSQL Servers including AWS Aurora
Experience working with blocking and deadlocking issues
Capacity Planning Experience
Experience Monitoring RDS SQL Server & PostgreSQL instances
Solid experience related to maintaining indexes and statistics
Detecting and solving Virtual Log File issues
Heavy TSQL or pgSQL scripting experience for backend processes as well as for usage by
applications
Experience with the development of ETL Layers and Report
Solid understanding of SQL Server & PostgreSQL internals
Experience designing and utilizing table partitioning as well as data archiving practices
Experience leveraging QueryStore
Experience in Agile Application Development & Scrum methodologies
Experience with either PowerShell or Python programming
Microsoft Certified Solutions Expert: Data Management and Analytics preferred
Job Responsibilities:
Play a lead role in all aspects of database management including installation, patching,
backup, recovery, performance, tuning, security, and space management
Maintain and Optimize functions, procedures, database queries, indexes, statistics
Ensuring database integrity
Implementing/maintaining database-related monitoring and alerting
Analyze logs, and metrics, to find improvements to implement
Work closely with both the Cloud Operations team and the R&D teams to support them in
optimizing the different product modules
Discuss complex database challenges closely with the development teams
Monitor and create database performance tests, making sure they stay on great levels
Continuously improve the way we work
Tasks:
SQL Operations
Quarterly SQL Server Maintenance (Patching, Updates, etc.)
Backup Management
Monitoring & Alerts
Scaling — IOPS, RAM, Size, etc.
Disk Usage, CPU, Index, Blocked Queries
Integrations: Datadog & PagerDuty
Growth – Provisioning / Scaling
Configuration Monitoring and Control
Encryption
RI’s
ADO Backlog Items
Product Support
Index Management (Ongoing)
SQL Reviews (Adhoc)
Project
Monthly Billing Process and Data Extracts
What We Offer
Exciting Projects: We focus on industries like High-Tech, communication, media, healthcare, retail and telecom. Our customer list is full of fantastic global brands and leaders who love what we build for them.
Collaborative Environment: You Can expand your skills by collaborating with a diverse team of highly talented people in an open, laidback environment — or even abroad in one of our global centers or client facilities!
Work-Life Balance: GlobalLogic prioritizes work-life balance, which is why we offer flexible work schedules, opportunities to work from home, and paid time off and holidays.
Professional Development: Our dedicated Learning & Development team regularly organizes Communication skills training(GL Vantage, Toast Master),Stress Management program, professional certifications, and technical and soft skill trainings.
Excellent Benefits: We provide our employees with competitive salaries, family medical insurance, Group Term Life Insurance, Group Personal Accident Insurance , NPS(National Pension Scheme ), Periodic health awareness program, extended maternity leave, annual performance bonuses, and referral bonuses.
Fun Perks: We want you to love where you work, which is why we host sports events, cultural activities, offer food on subsidies rates, Corporate parties. Our vibrant offices also include dedicated GL Zones, rooftop decks and GL Club where you can drink coffee or tea with your colleagues over a game of table and offer discounts for popular stores and restaurants!