Search Jobs

SQL DBA

This requirement is valid till 02-08-2019

Required Skills:

  SQL DBA
Location:  Bangalore, Trivandrum
Domain:  IT & ITES
Qualification:  Any Degree
Experience:  5-9 yrs.
Job Description with Roles & Responsibilities:      Design, develop and administer business application databases and associated program software in current and future Database and Application Infrastructure including Application Hosting Technologies, MySQL environments.
    Undertake performance monitoring and tuning, problem resolution, availability management, capacity management, change management and security access management to ensure the continuous provision of service of the database and integrated platform environments.
    Provide 24*7 support on rotation basis
    Provide advanced skills in the areas of fault diagnosis and failure and initiate remedial action as required in Database and Application Infrastructure environments.
    Perform complex backup and recovery tasks for database and applications infrastructure environments. Design the database recovery and backup policy and procedures in accordance with business requirements.
    Planning out strategies for DB migration, DB consolidation and driving it end to end.
    Provide a high level of technical expertise, advice and guidance on technology aspects of database and application delivery services to management and other technical staff.
    Strong documentation skills in documenting processes, procedures and tools descriptions.
    Responsible for maintaining strong partnerships and working relationships with dependent internal IT groups geographically
    Participate in and contribute to Release activities including Spec reviews.
    Understand and contribute to effective Monitoring of the critical components of the System.
    Drive the implementation of continuous improvement activities including new support tools and automation
    Ensure database security, integrity, and performance
    Proactive approach to database design, development, and management
    Recommend, implement, and maintain best practices and corporate standards



Skillset:  MySQL:
Key Skills:    SQL DBA, Database Activity Monitoring tools
    L3/L4 experience with at least two DB platforms With MySQL being the primary skill. Other platforms can be one or more on MSSQL, MongoDB, Cassandra and PostgreSQL.
    Experience managing relational MySQL and non-relational database servers such as MongoDB and Cassandra
    Experience in any one of the configuration management tools -Ansible/Puppet/Chef or SaltStack
    Experience with cloud-based database administration and its echo system (AWS, Rightscale, Cloudwatch, DataDog, zabbix, Monyog)
    Experience with designing and implementing high-availability database features, utilizing various replication and disaster recovery methodologies.
    Experience defining and implementing database management tools across entire database platform to ensure database performance and stability is maximized across the entire organization
    Thorough understanding Linux/Unix server performance tuning at the OS level.
    Experience with databases hosted on Windows/ AIX / Linux / AWS is must.
    Strong knowledge of RMAN and other migration tool/utilities.
    Candidate must be familiar with various DR and HA solutions in MySQL, MongoDB and Oracle.
    Candidate must have experience with using databases available in Amazon RDS platform
    Candidates should have good experience with backup and recovery of database
    Experience in shell/perl scripting.

MS SQL:
Key Skills:    MSSQL 2012, 2016
    L3/L4 experience with MSSQL and secondary skill as MySQL or NoSQL
    Experience with databases hosted on Windows/ Linux  /Azure/ AWS is must.
    Extensive experience on Standby database concepts
    Strong knowledge of migration tool/utilities.
    Candidate must be familiar with various DR and HA solutions in Sql Server, MySQL, Mongo db.
    Candidate must have experience with using databases available in Amazon RDS and Azure platform.
    Candidates should have good experience with backup and recovery of database.


 

Login to Apply