SQL Database Administrator
Apply NowCompany: Scout Exchange
Location: Warren, NJ 07059
Description:
Role: SQL Database Administrator
Rate: $45/hour all inclusive
Location: 100 Corporate Center Dr, Warren, NJ 07059 (Onsite)
Visa Type: USC, GC, H1B
About the Role:
We are seeking a skilled and experienced Database Administrator to manage, maintain, and optimize Oracle databases and Azure PaaS database services. The ideal candidate will have a strong background in Oracle DB administration, with expertise in deploying, configuring, and managing databases in cloud environments, particularly within Azure's Platform as a Service (PaaS) offerings.
Key Responsibilities:
Database Management:
o Install, configure, and manage Oracle databases across multiple environments (development, testing, and production).
o Perform routine database maintenance tasks such as backups, recovery, and patch management.
o Implement and manage high availability (HA) and disaster recovery (DR) solutions for Oracle databases.
o Monitor database performance, optimize SQL queries, and resolve performance bottlenecks.
o Ensure database security by managing users, roles, and permissions.
Azure PaaS Services:
o Deploy and manage Azure PaaS database services such as Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL.
o Configure and manage database scaling, performance tuning, and automated backups within Azure.
o Collaborate with cloud architects to design and implement scalable, secure, and cost-effective database solutions on Azure.
o Ensure seamless integration between on-premises Oracle databases and Azure cloud services.
Automation & Scripting:
o Develop and maintain scripts for database automation tasks, including deployments, monitoring, and maintenance.
o Implement Infrastructure as Code (IaC) practices using tools like Azure Resource Manager (ARM) templates, Terraform, or Ansible for database infrastructure management.
Collaboration & Support:
Work closely with development, operations, and security teams to ensure the databases meet project requirements and are aligned with best practices.
Provide technical support and troubleshooting for database-related issues, including after-hours support as needed.
Document database architectures, configurations, and processes to ensure clear communication and knowledge sharing across teams.
Required Qualifications:
Bachelor's degree in Computer Science, Information Technology, or a related field.
5+ years of experience as a Database Administrator with a focus on Oracle databases.
Strong understanding of Oracle DB architecture, PL/SQL, and performance tuning.
Experience managing and administering Azure PaaS database services (Azure SQL Database, PostgreSQL, MySQL).
Proficiency in database backup and recovery, high availability, and disaster recovery solutions.
Hands-on experience with database migration from on-premises to Azure cloud.
Knowledge of scripting languages (e.g., PowerShell, Python, Shell) for automation.
Familiarity with Azure Resource Manager (ARM) templates, Terraform, or other IaC tools.
Excellent problem-solving skills and the ability to work independently or as part of a team.
Preferred Qualifications:
Oracle Certified Professional (OCP) certification.
Microsoft Certified: Azure Database Administrator Associate.
Experience with containerized database deployments using Docker and Kubernetes.
Knowledge of DevOps practices and CI/CD pipelines related to database management.
Familiarity with cloud cost management and optimization strategies.
Rate: $45/hour all inclusive
Location: 100 Corporate Center Dr, Warren, NJ 07059 (Onsite)
Visa Type: USC, GC, H1B
About the Role:
We are seeking a skilled and experienced Database Administrator to manage, maintain, and optimize Oracle databases and Azure PaaS database services. The ideal candidate will have a strong background in Oracle DB administration, with expertise in deploying, configuring, and managing databases in cloud environments, particularly within Azure's Platform as a Service (PaaS) offerings.
Key Responsibilities:
Database Management:
o Install, configure, and manage Oracle databases across multiple environments (development, testing, and production).
o Perform routine database maintenance tasks such as backups, recovery, and patch management.
o Implement and manage high availability (HA) and disaster recovery (DR) solutions for Oracle databases.
o Monitor database performance, optimize SQL queries, and resolve performance bottlenecks.
o Ensure database security by managing users, roles, and permissions.
Azure PaaS Services:
o Deploy and manage Azure PaaS database services such as Azure SQL Database, Azure Database for PostgreSQL, and Azure Database for MySQL.
o Configure and manage database scaling, performance tuning, and automated backups within Azure.
o Collaborate with cloud architects to design and implement scalable, secure, and cost-effective database solutions on Azure.
o Ensure seamless integration between on-premises Oracle databases and Azure cloud services.
Automation & Scripting:
o Develop and maintain scripts for database automation tasks, including deployments, monitoring, and maintenance.
o Implement Infrastructure as Code (IaC) practices using tools like Azure Resource Manager (ARM) templates, Terraform, or Ansible for database infrastructure management.
Collaboration & Support:
Work closely with development, operations, and security teams to ensure the databases meet project requirements and are aligned with best practices.
Provide technical support and troubleshooting for database-related issues, including after-hours support as needed.
Document database architectures, configurations, and processes to ensure clear communication and knowledge sharing across teams.
Required Qualifications:
Bachelor's degree in Computer Science, Information Technology, or a related field.
5+ years of experience as a Database Administrator with a focus on Oracle databases.
Strong understanding of Oracle DB architecture, PL/SQL, and performance tuning.
Experience managing and administering Azure PaaS database services (Azure SQL Database, PostgreSQL, MySQL).
Proficiency in database backup and recovery, high availability, and disaster recovery solutions.
Hands-on experience with database migration from on-premises to Azure cloud.
Knowledge of scripting languages (e.g., PowerShell, Python, Shell) for automation.
Familiarity with Azure Resource Manager (ARM) templates, Terraform, or other IaC tools.
Excellent problem-solving skills and the ability to work independently or as part of a team.
Preferred Qualifications:
Oracle Certified Professional (OCP) certification.
Microsoft Certified: Azure Database Administrator Associate.
Experience with containerized database deployments using Docker and Kubernetes.
Knowledge of DevOps practices and CI/CD pipelines related to database management.
Familiarity with cloud cost management and optimization strategies.