Database Administrator

Job Responsibilities:

• Install, monitor, and maintain PostgreSQL software, implement monitoring and alerting, implement backup and recovery processes, provide system and SQL performance tuning and assist in business process integration with various data sources.
• Fulfills user requests ranging from access control, backup, restore, refresh to non-production to performance tuning.
• Provides online & on call coverage for production support and administration of MongoDB, and SQL on Hadoop
• Implement and maintain database code in the form of stored procedures, scripts, queries, views, triggers, etc.
• Work closely with the CTO to implement effective and maintainable database coding practices that form an architectural foundation.
• Work with front end developers to define simple yet powerful APIs.
• Work with GIS analysts to implement geospatial processes, queries and reports.
• Work with DBAs to ensure efficiency of database code, integrity of data structures and quality of data content.
• Work with product managers to ensure database code meets requirements.
• Work with DBAs and data analysts to ensure database code is accurately documented.
• Participate as a member in Agile teams, and work with other team members to review user stories, estimate effort to build functionality supporting user stories, and participate in sprint reviews

Requirements:

• B.Tech/B.E. in Any Specialization & BCA or MCA
• 3+ years working as a database developer working with PostgreSQL
• Expert Level SQL, PL/pgSQL, including stored procedures, functions, triggers, and views.
• PG :MCA in Any Specialization, MS/M.Sc(Science) in Any Specialization, M.Tech in Any Specialization, Post Graduation Not Required
• Knowledge of JSON and PostgreSQL support for JSON.
• PostGIS proficiency and grasp of core geospatial concepts.
• Ability to efficiently write database code without compromising data quality, privacy or security.
• Knowledge of database design principles, query optimization, index management, integrity checks, statistics and isolation levels
• Able to handle multiple tasks in a fast paced environment
• Excellent verbal, written, and interpersonal communication skills
• Ability to evaluate alternative solutions and/or workarounds
• Ability to evaluate alternative solutions and/or workaround

Behavioral Competencies:

• High attention to detail regarding accounting skills
• Ability to work under indirect supervision.
• Good problem-solving skills
• Strong verbal and written communication skills.
• Ability to influence technical discussions and decisions.