P1-C3-STS
Sr. DB Engineer
Database Development & Programming: Develop and Maintain Complex Stored procedures, Functions, Triggers, Using SQL and PLSQL, PostgreSQL. Familiarity With Complex data types like LOB, JSON, XM and array/Object Handling in DB. Database: Oracle, PostgreSQL, MySQL
Performance Tuning & Optimization: Troubleshoot Database performance Issues, Proficient in Analysing and tuning complex SQL queries and Optimize them using Indexing, Statistics, Partitioning and execution plan. Monitor and tune DB performance and capacity in both OLTP and OLAP environments. Database Migrations: Plan and execute end-to-end database migrations. work with tools Like AWS DMS, SCT, ORA2PG and custom ETL scripts to support migration. Ensure data Quality, integrity and Security throughout the migration and transformation Process.
Cloud Database Exposure: Work with Cloud Native DB such as AWS RDS, Aurora, Azure SQL. Experience in Building ETL workflows and Data Pipelines orchestration. Scripting and Automation: Build Automation Scripts using Python and Shell Scripting for monitoring, Housekeeping, data Loads and reporting. Develop data transformation and Loading utilities for various DB systems.
Job Scheduling and Monitoring: Manage Scheduled DB jobs using tools like Cron, AWS AIR Flow, Control-m etc. Ensure Proper Logging, Error handling and alerting Mechanism are in place for scheduled tasks. Schema Management and Governance: Design and Manage DB schemas, relationship, Constraints and naming Conventions. Support Data Modelling and integration efforts with application.
Collaboration and documentations: Work closely With Client, APP developers, data engineers, architects and DEVOPS teams. Maintain Detailed Technical Documentation Standard Operating Procedures.
Design and implement scalable and high-availability database architectures. Develop and enforce database standards, procedures, and best practices. Work with software architects and developers to translate application requirements into DB schemas and data models.
Write complex SQL queries, stored procedures, functions, and triggers. Develop and maintain ETL Extract, Transform, Load processes. Support database versioning and migration scripts. Analyze and resolve database performance issues (e.g., slow queries, deadlocks). Optimize indexing, partitioning, caching, and query execution plans. Monitor database performance metrics and perform regular tuning.
Implement and monitor database security measures (access controls, encryption). Ensure compliance with data governance and regulatory requirements (GDPR, HIPAA, etc.). Perform audits and risk assessments related to data security.
Oversee backups, restores, and disaster recovery strategies. Automate routine tasks (backups, archiving, indexing). Ensure high availability and data redundancy where needed. Work closely with DevOps, software engineers, QA, and BI teams. Mentor junior DBAs/engineers and share knowledge across the team. Participate in code reviews and database-related design discussions.
Evaluate and implement database tools (e.g., monitoring, backup, replication). Integrate databases with CI/CD pipelines and infrastructure automation tools. Support hybrid or multi-cloud database deployments, if applicable.
About Virtusa
Teamwork, quality of life, professional and personal development: values that Virtusa is proud to embody. When you join us, you join a team of 27,000 people globally that cares about your growth — one that seeks to provide you with exciting projects, opportunities and work with state of the art technologies throughout your career with us.
Great minds, great potential: it all comes together at Virtusa. We value collaboration and the team environment of our company, and seek to provide great minds with a dynamic place to nurture new ideas and foster excellence.
Virtusa was founded on principles of equal opportunity for all, and so does not discriminate on the basis of race, religion, color, sex, gender identity, sexual orientation, age, non-disqualifying physical or mental disability, national origin, veteran status or any other basis covered by appropriate law. All employment is decided on the basis of qualifications, merit, and business need.
