Job
Description
Job Title Oracle & MS-SQL and PostgreSQL DBAExperience 8-16 YearsLocation Bangalore
:
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 toMongo 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 Oracle APPS DBA PRIMARY PERCENTAGE 51 SECONDARY COMPETENCY Big Data Technologies SECONDARY PostgreSQL SECONDARY PERCENTAGE 39 TERTIARY COMPETENCY Data Engineering TERTIARY Microsoft SQL Server APPS DBA TERTIARY PERCENTAGE 10