Database Administrator

Duties & Responsibilities:

• Provide DBA support for SQL server on Azure VMs and Azure SQL Managed Instances
  
• Provide Oracle DBA support including patching databases and partitioning tables.
  
• Manage SQL server databases on Azure VMs and Azure SQL Managed Instances
  
• Backup and restore SQL databases on Azure VMs and Managed Instances.
  
• Monitor SQL Agent jobs and respond to critical job notifications. Troubleshoot and resolve the issues and if needed escalate issues and facilitate problem resolution.
  
• Troubleshoot SSIS package failures and facilitate problem resolution.
  
• Automates common database management tasks. 
  
• Creating documentation, maintenance plans, assigning and monitoring threshold values
  

What you Bring to the Table:

• Create and evolve application documentation as required
  
• Ensure that technical solutions follow best practices, are reliable and are easily maintainable.
  

Requirements

Basic Qualifications:

• Bachelors degree in computer science, Information Systems, or related field.
  
• 3+ years Oracle DBA experience
  
• Hands-On Experience managing SQL database on Azure
  
• Experience with backup strategies, and DR solutions for Oracle databases 
  
• Experience with table partitioning and reorg in Oracle
  
• Experience with SQL transactional replication
  
• Experience in monitoring and tuning MS SQL Server databases for optimum performance
  
• Knowledge of indexes, analyzing query plans for performance tuning 
  
• Knowledge of SQL Server Integration Service (SSIS)
  
• Knowledge of Linux shell scripting
  
• Knowledge of Oracle Enterprise Manager preferred 
  
• Experience with ADF will be a plus
  
• Proficient understanding of code versioning tools, such as Git / SVN
  

Preferred Qualifications: