Developer Programmer - 261312

at  TECH MAHINDRA

PRIMARY OR MANDATORY SKILLS :-

· Oracle (RAC & Single Instance)
· Red Hat OCP (Both AWS and On-Prem)
· PostgreSQL (RAC & Single Instance)
· MySQL (RAC & Single Instance)
· SQL Server (RAC & Single Instance)
· Database Performance Tunning
· Database Monitoring configuration and management
· Database Backup and Recovery
· Database User Management and Security
· Database and Oracle Engineered System Patch Management

GOOD TO HAVE SKILLS :

LINUX, AIX, SOLARIS, HP-UNIX, WINDOWS, SQL LANGUAGUE, TSQL, Exa-CC , Exa-Data , DELL EMC Net Backup , NAGIOS , DYNATRACE , IT ASSIST , OEM , AWS EC2 , DB2

DETAILED JOB DESCRIPTION : -

· Manage and Maintain databases like Oracle, PostgreSQL, MySQL and SQL Server, along with RAC for each of the database types.
· Perform Quarterly and Monthly patching for all the databases including Oracle, PostgreSQL, MySQL and SQL Server, hosted on any of the platform like AWS (EC2) , Red hat OCP , Exa-CC , Unix , AIX and Solaris.
· Work with business analysts and stakeholders to define and understand data requirements, including storage, access, and retrieval needs.
· Perform database/schema backup or restore as per requirement from the business or the application.
· Assess the feasibility of database-related requirements, identifying which DBMS features (e.g., PL/SQL for Oracle or T-SQL for SQL Server) best suit the project’s needs.
· Collaborate to define data structures and specifications, considering business rules, relationships, and constraints for optimal performance and integrity.
· Design database schemas, including tables, views, indexes, and relationships, following best practices for normalization and performance optimization.
· Leverage database-specific features like Oracle’s partitioning, SQL Server’s clustered indexes, or PostgreSQL’s JSONB support to ensure performance and scalability.
· Develop optimized SQL queries, stored procedures, functions, and triggers to handle data-related logic efficiently.
· Use database-specific query languages (e.g., PL/pgSQL in PostgreSQL, PL/SQL in Oracle, T-SQL in SQL Server) to achieve complex data operations.
· Design and implement data access layers in the application code, following best practices for connecting to and interacting with databases securely and efficiently.
· Test complex queries and stored procedures for accuracy and performance, using tools like EXPLAIN plans or profiling to optimize execution paths.
· Perform integrity checks, ensuring data is consistent across tables and complies with business rules and constraints.
· Troubleshoot data-related issues such as slow queries, deadlocks, or inconsistent data, using diagnostic tools like SQL Profiler for SQL Server or pgAdmin for PostgreSQL.
· Regularly optimize database performance by adjusting indexes, rewriting queries, and archiving data as needed.
· Address incidents involving data access, data integrity, or performance issues, resolving them within the specified SLA.
· Implement and test schema changes or updates, coordinating with DBAs to minimize downtime and disruption to applications.
· Follow best practices for secure data handling, such as using parameterized queries to prevent SQL injection, encrypting sensitive data, and following access control protocols.
· Ensure database structures and queries comply with data protection and privacy regulations (e.g., GDPR, HIPAA), and apply role-based access controls where needed.
· Set up audit trails, where required, to monitor data access and modifications, particularly in systems with sensitive data.
· Seek ways to improve data workflows and processes, introducing automation or improved query patterns to streamline performance.
· Coordinate database changes across development, testing, and production environments
· Monitor database performance post-deployment, quickly addressing any issues that arise from new code or schema changes.
Job Type: Full-time
Pay: $100,000.00 – $120,000.00 per year
Work Location: In perso

Please refer the Job description for details