Senior Database Administrator

3 weeks ago


Chennai India Fidelity Investments Full time

Job Description

Job Description

Job Title: Senior Database Administrator

The Purpose of This Role

Application DBA Lead role is a Production Database Support team under WI Data Engineering Team. This team supports various databases to manage WI critical applications for the business. WI Database Administration Support group provides database services related to the Oracle, SQL, PostgreSQL hosted in On-Premises, Azure / AWS and Distributed databases infrastructure for multiple clients facing internal and external applications.

Production Support which includes 7x12 on call support, Database Infrastructure Support, performance monitoring, 1st level performance troubleshooting, Risk/Audit compliance and Non-Production database refreshes. Database and Oracle Application Maintenance includes Oracle Database upgrades, Database reorganizations, Security Patching, Application Upgrades.

The Value You Deliver

Database Administrator is core member of Application Database Support team working on Linux Servers and Oracle databases mainly to ensure stability and availability for Business critical applications. DBA should be able to collaborate with multiple teams to,

- Ensuring Production Stability
- Providing database application life cycle support.
- Database design, development and implementation.
- Supporting Non-Production and Production environments.
- Recommending solutions on database and application architecture.
- Maintaining database security controls and availability.
- Supporting application tuning.
- Managing database and server compliance
- Ensuring data security
- Providing high availability solutions
- Try out new technologies to adapt

The Skills That Are Key To This Role

Technical / Behavioral

- Database designing and configuring in any UNIX / Windows environment.
- Should possess strong skillset in troubleshooting.

- Oracle Database Standalone/ RAC
- Replication technologies
- SQL Database Management in Windows and Azure
- PostgreSQL Database Management in Azure
- AWS/Azure Managed Databases

- Oracle DBA Knowledge

- User management
- Space management
- Performance tuning
- SQL tuning
- Backup and Recovery
- Disaster Recovery Management
- RAC with ASM
- Flashback Technologies
- Data Masking
- Database upgrade and patching

- SQL DBA Knowledge

- Proficiency in installing, upgrading, and configuring SQL Server instances, including setting up various features and services
- Ability to create and modify databases, tables, indexes, and other database objects.
- Expertise in identifying and resolving performance bottlenecks, optimizing queries, managing indexes, and understanding execution plans.
- Implementing and managing database security, including user authentication, authorization, roles, permissions, and data encryption.
- Developing and implementing robust backup strategies, performing data recovery operations, and understanding disaster recovery concepts.
- Implementing and managing solutions like AlwaysOn Availability Groups, Database Mirroring, Log Shipping, and Clustering to ensure continuous data availability.
- Utilizing SQL Server tools and techniques to monitor database performance, identify issues, and troubleshoot problems effectively.
- Strong proficiency in querying, manipulating, and managing data and database objects.
- Familiarity with cloud platforms like Azure SQL Database and Azure SQL Managed Instance if managing cloud-based SQL Server environments.

- Postgres DBA knowledge

- Database management skills of data administration, web connectivity/managing connections, physical structure, and overall architecture and database analysis v12 above.
- Responsible for backup, recovery and upgrading of postgres databases. ETL and data-warehouse design experience.
- Proficient with major PostgreSQL procedural languages viz, PL/PgSQL as well some Oracle SQL-PL/SQL.
- Configuring Postgres Streaming Replication, Logical replication, BARMAN, EFM and Load balancing.
- Managing monitoring tools for better performance like PGbadger

- Should have knowledge in Configuring., Monitoring and Administering through OEM
- Oracle Database
- GoldenGate
- ASM
- Oracle Performance Management
- Middle Tier
- Being proactive in maintenance activities and security management.
- Open to adapt new technologies.
- Should have strong relationship management skills.
- Should have knowledge in ITIL process.
- Having knowledge in EXADATA would be an advantage.
- Should be able to be part of solutions and problem management.
- Provide 12x7 support and ensure that all critical database problems are resolved in a timely manner
- Should have knowledge in GoldenGate replication
- Configuring and administration
- Managing all kinds of replication
- Heterogeneous replication
- Should have strong knowledge on Unix scripting.
- Possess knowledge in UDeploy
- Having knowledge in DevOps model
- Having knowledge in No-SQL databases
- Being responsible and taking ownership.
- Being open to the challenges coming up.
- Excellent written and verbal communication
- Excellent problem solving and decision-making skills
- Ability to work effectively with onshore and offshore partners and team members
- Be the promoter of change, continuously drive innovation leading by example
- Must have a flexible attitude and be able to comfortably accommodate change

The Skills that are Good To Have for this role

- Good understanding on Replication Technologies
- Good understanding on Cloud Technologies and Relational Data Services
- Good understanding on DevOps tools (Jenkins)
- Good understanding on NoSQL databases (Aerospike)
- Good understanding on Distributed databases concepts Yugabyte/Aerospike/Snowflake

How Your Work Impacts The Organization

You would be able to contribute in maintaining stability of our databases by upkeeping infrastructure uptime through appropriate security patches, upgrades and database monitoring, managing the stakeholder's deliverables, being a mentor for group of DBA's on technology front and especially managing the performance of databases to meet the service timelines. Being a change agent to adapt to new technologies.

The Expertise We're Looking For

- 6+ years of IT experience
- Engineering Graduate

Location : Chennai - DLF/Bangalore - EGL

Shift timings: 11:00 AM - 8:00PM

Certifications

Category:

Information Technology



  • Delhi, India, India ThoughtSol Infotech Ltd. Full time

    Job Title: Senior Database Administrator (DBA)Location: NoidaExperience: 4-5 YearsRole OverviewWe are seeking a skilled Senior Database Architect & DBA with 4–5 years of experience indesigning, implementing, and administering enterprise-grade SQL databases. The roleblends strategic database architecture with day-to-day database administration,...


  • Hyderabad, India Softility, Inc. Full time

    Job Description Softility is currently seeking a Senior PostgreSQL Database Administrator to join our Hyderabad & Chicago, US offices. As a Senior Postgres DBA, you'll need to manage multiple projects simultaneously and make the best decisions in the moment and in the long term for the company. You will work in a team environment to provide expertise in...


  • India CitNOW Group Full time

    About usFounded in 2008, CitNOW is an innovative, enterprise-level software product suite that allows automotive dealerships globally to sell more vehicles and parts more profitably. CitNOW’s app-based platform provides a secure, brand-compliant solution – for dealers to build trust, transparency and long-lasting relationships.CitNOW Group was formed in...


  • Pune, Maharashtra, India, Maharashtra thinkbridge Full time

    We are hiring a Senior Database Administrator with 6+ years of experience in Data structures, Performance tuning optimization (PTO), Database security, Backup, and Recovery processes.About thinkbridgethinkbridge is how growth-stage companies can finally turn into tech disruptors. They get a new way there – with world-class technology strategy, development,...


  • India CitNOW Group Full time

    About us Founded in 2008, CitNOW is an innovative, enterprise-level software product suite that allows automotive dealerships globally to sell more vehicles and parts more profitably. CitNOW’s app-based platform provides a secure, brand-compliant solution – for dealers to build trust, transparency and long-lasting relationships. CitNOW Group was formed...


  • Chennai, India Apdeops Technologies Pvt Ltd Full time

    Job Description Company Description Apdeops Technologies Pvt Ltd is driven by thoughts inspired by technology and innovation. We help businesses and individuals by fostering digital intelligence and transformation. Our aim is to enhance people's lives and improve businesses through our progressive and innovative technology solutions. Role Description This is...


  • Chennai, India Anthology Inc Full time

    Description 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...


  • Chennai, India Anthology Inc Full time

    Description 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....


  • Hyderabad, India Congregate Technologies Full time

    Job Description Role Overview We are seeking an experienced Senior AWS Database Administrator to manage, optimize, and secure mission-critical database systems on AWS, including RDS and Aurora for MySQL, PostgreSQL, and MSSQL. Responsibilities This role involves ensuring high availability, performance tuning, security compliance, and supporting large scale...


  • india Tata Consultancy Services Full time

    *Role Microsoft SQL Server Database Administrator – L2 *Required Technical Skill Set Microsoft SQL Server 2000, 2005, 2008 R2 & 2012 Administration *Desired Experience Range 6-8 years *Location :Pune, Chennai *Notice Period:0-45 Days candidates Only Virtual Drive Date: 03-Oct-25Desired Competencies (Technical/Behavioral Competency) Must-Have · 3 - 6 years...