Job Title        : Oracle & MS-SQL and PostgreSQL DBA
Experience    : 8-16 Years
Location        : Bangalore

Job Description :

· Must have 4 Year degree (Computer Science, Information Systems or equivalent)

· 8+ years overall IT experience (5+ Years as DBA)

Technical Skills:

· Hands-on expertise in data migration between databases on-prem to AWS cloud RDS.

· Experience in usage of AWS Data Migration Service (DMS)

· Experience in export/import of huge size Database Schema, full load plus CDC.

· Should have knowledge & experience in Unix command and writing task automation shell scripts.

· Knowledge & experience on Different Backup/restore methods and backup tools is needed.

· Experienced with hands on experience in DBA Skills of database monitoring, performance tuning, DB refresh.

· Hands on experience in Database support.

· Hands-on expertise in data migration between databases on-prem to Mongo Atlas .

· Experience in creating clusters, databases and creating the users.

· Hands-on expertise in data migration between databases on-prem to AWS cloud RDS (postgres)

· SQL Server Administration: Install, configure, upgrade, and manage SQL Server databases hosted on AWS EC2, RDS.

· AWS Cloud Integration: Design, deploy, and manage SQL Server instances using AWS services like RDS, EC2, S3, CloudFormation, and IAM.

· Performance Tuning: Optimize database performance through query tuning, indexing strategies, and resource allocation within AWS environments.

· High Availability and Disaster Recovery: Implement and manage HA/DR solutions such as Always On Availability Groups, Multi-AZ deployments, or read replicas on AWS.

· Backup and Restore: Configure and automate backup strategies using AWS services like S3 and Lifecycle Policies while ensuring database integrity and recovery objectives.

· Security and Compliance: Manage database security, encryption, and compliance standards (e.g., GDPR, HIPAA) using AWS services like KMS and GuardDuty.

· Monitoring and Automation: Monitor database performance using AWS CloudWatch, SQL Profiler, and third-party tools. Automate routine tasks using PowerShell, AWS Lambda, or AWS Systems Manager.

· Collaboration: Work closely with development, DevOps, and architecture teams to integrate SQL Server solutions into cloud-based applications.

· Documentation: Maintain thorough documentation of database configurations, operational processes, and security procedures.

Non-Technical Skills :

· Candidate needs to be Good Team Player

· Ownership skills- should be an individual performer to take deliverables and handle fresh challenges.

· Service/Customer orientation/ strong oral and written communication skills are mandate. Should be confident and capable to speak with client and onsite teams.

· Effective interpersonal, team building and communication skills.

· Ability to collaborate; be able to communicate clearly and concisely both to laypeople and peers, be able to follow instructions, make a team stronger for your presence and not weaker.

· Should be ready to work in rotating shifts (morning, general and afternoon shifts)

· Ability to see the bigger picture and differing perspectives; to compromise, to balance competing priorities, and to prioritize the user.

· Desire for continuous improvement, of the worthy sort; always be learning and seeking improvement, avoid change aversion and excessive conservatism, equally avoid harmful perfectionism, 'not-invented-here' syndrome and damaging pursuit of the bleeding edge for its own sake.

· Learn things quickly, while working outside the area of expertise.

· Analyze a problem and realize exactly what all will be affected by even the smallest of change you make in the database.

· Ability to communicate complex technology to no tech audience in simple and precise manner.

Skills

• PRIMARY COMPETENCY : Data Engineering
• PRIMARY SKILL : Oracle APPS DBA
• PRIMARY SKILL PERCENTAGE : 51
• SECONDARY COMPETENCY : Big Data Technologies
• SECONDARY SKILL : PostgreSQL
• SECONDARY SKILL PERCENTAGE : 39
• TERTIARY COMPETENCY : Data Engineering
• TERTIARY SKILL : Microsoft SQL Server APPS DBA
• TERTIARY SKILL PERCENTAGE : 10