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
