Description

Administer enterprise database systems and applications to ensure availability, performance, and security across development, test, and production environments.

This role is on-site.

Responsibilities

• Administer and maintain Oracle and SQL Server database systems, ensuring integrity, security, and optimal performance.
• Design, create, and modify database structures, including tables, indexes, stored procedures, triggers, and views.
• Monitor, troubleshoot, and optimize database performance through execution plan analysis, capacity planning, and tuning.
• Manage database changes, deployments, code migrations, backups, recovery, and disaster recovery operations.
• Implement and enforce database security policies, access controls, and user provisioning across environments.

Required Skills

• 5+ years of experience with Oracle and SQL Server database administration.
• Proficiency in T-SQL programming and Transact-SQL scripting.
• Experience with ETL processes, data replication, and transaction processing.
• Ability to create and manage SQL Server maintenance plans and database objects.
• Proficiency in writing and troubleshooting scripts using PowerShell and CMD commands.
• Experience with database reporting tools such as SSRS, Business Objects, Oracle BI, and Power BI.
• Strong understanding of database architecture, design, and integration with internal/external systems.

Preferred Skills

• Experience with high-availability environments and patch management.
• General software programming concepts and proficiency in additional programming languages.
• Ability to analyze and resolve issues from system, application, and database logs.

Key Skills

Education

Any Graduate