Data Base Administrator

Our Client company is into Telecommunications. (SY1)

Data Base Administrator

Data Base Administrator at Our Client company is into Telecommunications. (SY1) · Bengaluru (Bangalore) · 7 - 10 years · ₹20L - ₹25L / yr · Posted 26 May 2021

Data Base Administrator

at Our Client company is into Telecommunications. (SY1)

Agency job

via Multi Recruit

7 - 10 yrs

₹20L - ₹25L / yr

Bengaluru (Bangalore)

Skills

Cassandra Administration

Database administration

MariaDB

PostgreSQL

MySQL

MySQL DBA

Cassandra administration

Design, develop and manage data on various open-source SQL databases
End-to-end performance tuning of Oracle, MariaDB, MySQL, PostgreSQL, and Aurora against very large data sets
Database cluster connectivity and security
Conduct database training
Software installation and configuration
Database patching and upgrading
Using monitoring and management tools
Troubleshoot various issues with other dba’s/developers
Point of Contact for Vendor escalation
Point of Contact for professional service to Customers
Cross-platform migration from Oracle to MySQL/MariaDB/PostgreSQL/Aurora
Support the creation, maintenance, and implementation of procedures regarding how problems are identified, received, documented, distributed, and corrected
Ensures project documentation is complete, current, and stored appropriately
Manages day-to-day project and scope changes
Communicate and coordinate database changes, backups, and downtime to users
Identifies potential security issues and recommend strategies to ensure database security
Research and evaluate new technologies
Proactively monitor systems for optimum performance and capacity constraints
Establish standards and best practices for SQL
Interact with and coach developers in SQL scripting
Perform database backup and recovery
Provides 24x7 support for enterprise database systems

Secondary Functions

Must provide mentoring and training to other staff members
Write procedural documentation including requirements for databases
Develop and coordinate knowledge transfer
Establishes enterprise-wide uniform infrastructure, including supporting defined departmental content processes and creating guidelines for content deployment
Interacts with business units to gather, define, and organize the delivery of business solutions Data
Modeling, design & implementation based on established standards
Automate manual tasks

Who we have in mind:

Candidate with a college degree and relevant work experience
7+ years of hands-on DBA experience with Oracle, MySQL, MariaDB, and PostgreSQL and supporting tools
Strong experience with Linux is required, including command-line editors, scripting (shell, Python, Perl, etc.)
Experience in database performance tuning and strong SQL tuning skills
Experience in database and cross-platform upgrades required Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support
Must be familiar with RDBMS concepts, practices, and procedures
Must have knowledge of network connectivity
Extensive experience with Export/Import, Backup and Recovery
Extensive experience with Database Replication Master/Slave, Master/Master (BDR)
Extensive experience with MySQL (MariaDB, Percona) Galera cluster
Experience with MaxScale
Proficient in SQL Language
Knowledge of ServiceNow, or similar Ticket Management Software
Knowledge of SAN infrastructure including HP and NetApp
Ability to work on projects at a time
Knowledge of middle-tier application servers
Strong troubleshooting and problem resolution skills
Good knowledge of Data Modeling
Knowledge of XML and JDBC

It would be great if you had:

Experience of NoSQL databases (Cassandra, Oracle NoSQL, MongoDB) is a plus
Certifications on MySQL, PostgreSQL, and Aurora

Design, develop and manage data on various open-source SQL databases
End-to-end performance tuning of Oracle, MariaDB, MySQL, PostgreSQL, and Aurora against very large data sets
Database cluster connectivity and security
Conduct database training
Software installation and configuration
Database patching and upgrading
Using monitoring and management tools
Troubleshoot various issues with other dba’s/developers
Point of Contact for Vendor escalation
Point of Contact for professional service to Customers
Cross-platform migration from Oracle to MySQL/MariaDB/PostgreSQL/Aurora
Support the creation, maintenance, and implementation of procedures regarding how problems are identified, received, documented, distributed, and corrected
Ensures project documentation is complete, current, and stored appropriately
Manages day-to-day project and scope changes
Communicate and coordinate database changes, backups, and downtime to users
Identifies potential security issues and recommend strategies to ensure database security
Research and evaluate new technologies
Proactively monitor systems for optimum performance and capacity constraints
Establish standards and best practices for SQL
Interact with and coach developers in SQL scripting
Perform database backup and recovery
Provides 24x7 support for enterprise database systems

Secondary Functions

Must provide mentoring and training to other staff members
Write procedural documentation including requirements for databases
Develop and coordinate knowledge transfer
Establishes enterprise-wide uniform infrastructure, including supporting defined departmental content processes and creating guidelines for content deployment
Interacts with business units to gather, define, and organize the delivery of business solutions Data
Modeling, design & implementation based on established standards
Automate manual tasks

Who we have in mind:

Candidate with a college degree and relevant work experience
7+ years of hands-on DBA experience with Oracle, MySQL, MariaDB, and PostgreSQL and supporting tools
Strong experience with Linux is required, including command-line editors, scripting (shell, Python, Perl, etc.)
Experience in database performance tuning and strong SQL tuning skills
Experience in database and cross-platform upgrades required Experience in all aspects of the software development lifecycle including requirements gathering, design, coding, testing and production support
Must be familiar with RDBMS concepts, practices, and procedures
Must have knowledge of network connectivity
Extensive experience with Export/Import, Backup and Recovery
Extensive experience with Database Replication Master/Slave, Master/Master (BDR)
Extensive experience with MySQL (MariaDB, Percona) Galera cluster
Experience with MaxScale
Proficient in SQL Language
Knowledge of ServiceNow, or similar Ticket Management Software
Knowledge of SAN infrastructure including HP and NetApp
Ability to work on projects at a time
Knowledge of middle-tier application servers
Strong troubleshooting and problem resolution skills
Good knowledge of Data Modeling
Knowledge of XML and JDBC

It would be great if you had:

Experience of NoSQL databases (Cassandra, Oracle NoSQL, MongoDB) is a plus
Certifications on MySQL, PostgreSQL, and Aurora

Users love Cutshort

Read about what our users have to say about finding their next opportunity on Cutshort.

Shubham Vishwakarma

Full Stack Developer - Averlon

I had an amazing experience. It was a delight getting interviewed via Cutshort. The entire end to end process was amazing. I would like to mention Reshika, she was just amazing wrt guiding me through the process. Thank you team.