Job Description
Senior Database Administrator.
This position will interface with key stakeholders and apply your technical proficiency across different stages of the Software Development Life Cycle including Requirements Elicitation, Application Architecture definition and Design; play an important role in creating the high level design artifacts; deliver high quality code deliverables for a module, lead validation for all types of testing and support activities related to implementation, transition and warranty; be part of a learning culture, where teamwork and collaboration are encouraged, excellence is rewarded, and diversity is respected and valued.
Required Qualifications:
• BS in Computer Science or equivalent combination of technical education and experience
• Fluency in DB technologies and tools, DB development
• Excellent written and verbal communication skills, with a track record of working effectively with Development Engineering and other functions
• 7+ years of DBA Hands on experience in Database technology like PostgreSQL, MySQL and other database opensource technology
• Minimum 3+ year of experience in handling Redshift database support and AWS RDS
• Experience in a 24X7 production environment and large team.
• Experience analyzing issues holistically, from the application tier through the database, down to the storage.
• Broad awareness of customer workloads and use cases, including performance, availability, and scalability.
• Experience building and maintaining complex mission-critical production database systems.
• Experience in root cause analysis, remediation, and problem resolution for complex systems.
• Working knowledge in database systems architecture, including networking, security, scaling, and fault-tolerance.
• Experience working directly with internal and/or external customers in database software development and support.
Experience Related to Redshift Administration
· User management like creating Roles/Groups, databases, Schema's, user's and providing access accordingly.
· Check locks on tables and release them.
· Work on incidents and change request based on user request.
· Performance monitoring on queries of redshift environment.
· Restore backup tables from snapshot based on Adhoc request.
· Provide weekly redshift maintain details like vacuum analyser, delete, sort and deep-copy
· Monitor cluster console of redshift and abort queries if it is taking more time based on end user request.
· Spinning up of cluster on Redshift and doing re activities based on requirement.
Added advantage having Work experience on
· Cluster reboot on redshift environment.
· Datashare and redshift spectrum.
· SQL work bench/DB Visualizer/CLI for redshift environment.
· Experience in Unload and Copy commands.
· Knowledge on AWS services such as s3, IAM, DMS, Glue, Crawler, Cloudwatch, Cloud formation, EC2, Lambda and EMR.
• Definition of RDS instance requirements (defining compliance, engine type, instance class, license deployment, region, availability zones, subnet groups, security groups, etc.)
• Proficiency tuning databases for performance, availability, and scalability.
Preferred Qualifications
· Certification in AWS Database Specialty
