Job Description

Department Background

At Finxera, the DBA team has entered into a new era of managing infrastructure, taking initiatives for the benefit of our Product and organization, creating new policies and processes with respect to maintenance, security, sustenance, standard practices etc. apart from the day to day DBA activities. Our goal is to set examples of being cool and calm and solving any type issues with our product by taking proactive measures. We work with all teams starting from Product Manager, Developers, Testers, Architects, Infra team and many others. We believe in Cloud based managed services solutions with futuristic goals.

Position Purpose & Description

The position is open for a Database Administrator who should be able to take any type of database activities. You should have a strong knowledge of any type of database. You will be working closely with different teams and should be able to recommend both SQL and Database Server Tuning.


You might also have to write programs using different scripting languages. You will be frequently using Amazon Web Services Console to read and analyse the statistics of the Database servers. Your proactiveness to maintain the database as per expectations will prove your potential and ability to tackle challenges in production environments. You are expected to cooperate with team members as well as with other teams and maintain a friendly environment without compromising our responsibilities for the benefit of the organization.


Responsibilities
Qualifications/Criteria's



Automation of manual DBA activities. Recommending Tuning or redesign of SQLs. Writing Stored Procedures for capturing database statistics. Monitoring database from AWS console as well as directly login into the database. Maintenance of database as per SLA/expectations. Executing database scripts during deployments. Analysing and fixing production issues. Implement new strategies to ease the life of DBAs and develop ideas for more productiveness. Cooperating with different teams to solve any database issues. Receive On-Calls for any database activity in production. Writing design/approach/strategy documentation for the DBA activities. Any other type of DBA activities whenever required.

*Should have scored 70% & above in 10th and 12th grade.
B.Tech/B.E. in any stream or BCA/MCA or BSc. in Computer Science. Strong in writing SQL, SQL Performance Tuning. Hands on experience in writing stored procedures. Strong experience and knowledge of Database Administration in MySQL/Oracle. Database Server Tuning, Backup & Recovery. Proficiency in working with any Cloud Services preferably AWS. Knowledge of MongoDB Administration. Hands on experience in writing programs using Python, Linux Shell scripting etc. Familiarity with database tools such as Toad, MySQL Workbench, SQL Developer etc. Good in Technical Documentation. * Knowledge of basic Linux commands.