Designation / Job title : Developer Programmer - 261312Primary or Mandatory skills :-• Oracle (RAC & Single Instance)• Red Hat OCP (Both AWS and On-Pr.....
Designation / Job title : Developer Programmer - 261312
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.