Title: Database Administrator Specialist
Location: New York, NY - Hybrid
Duration: 6 months (Contract to hire)
Job Summary:
Responsible for the architecture, planning, design, development, implementation, administration, governance, and maintenance of the organization's databases and data platforms across multiple technologies and computing environments, including cloud-based, distributed, and client/server systems. Core platforms include Oracle, SQL Server, Microsoft Fabric, Snowflake, and PostgreSQL.
Essential Functions:
Your responsibilities will include but are not limited to the following:
- Architect, implement, administer, and support enterprise Oracle environments utilizing technologies such as Oracle RAC, Data Guard, RMAN, Oracle Enterprise Manager, partitioning, Diagnostics and Tuning Packs, performance tuning, backup and recovery, high availability, and disaster recovery.
- Architect, implement, administer, and support enterprise SQL Server environments, including SQL Server Availability Groups, Windows Clustering, performance tuning, backup and recovery, security, monitoring, high availability, and disaster recovery.
- Architect, implement, administer, and support Microsoft Fabric, Power BI, Snowflake, and Postgres environments, including CLI, RESTAPI, Capacity Metric app, Github Actions, OneLake, SnowSQL.
- Collaborate with application development, data engineering, analytics, infrastructure, security, compliance, and business teams to identify requirements, develop optimal solutions, and ensure seamless database and data-platform integration.
- Proactively analyze usage patterns, workload growth, storage consumption, and capacity demand to optimize resource allocation, platform performance, availability, and cost.
- Lead initiatives to improve database and data-platform operational efficiency, reliability, scalability, agility, observability, and automation.
- Develop and maintain architecture documentation, operational standards, monitoring procedures, recovery runbooks, capacity plans, security standards, and support documentation.
- Research and evaluate emerging databases, cloud, analytics, and Microsoft Fabric technologies to identify opportunities for platform modernization, automation, governance improvement, and operational efficiency.
- Provide production support and participate in incident response, root-cause analysis, problem management, change management, disaster-recovery testing, planned maintenance, migrations, upgrades, and platform deployments.
Your required skills must include:
- Bachelor's degree in Information Management, Information Technology, Computer Science, or a related field, or equivalent professional experience.
- Minimum of 10 years of hands-on database administration experience supporting large-scale, mission-critical production environments.
- Extensive hands-on experience on administering and supporting databases and data platforms including Oracle RAC, Data Guard, RMAN, Oracle Enterprise Manager, partitioning, Diagnostics and Tuning Packs, PL/SQL, SQL Server Availability Groups, Windows Clustering, security, Fab CLI, Admin Portal, and Capacity Metric App,
- Experience with scripting and automation technologies such as PL/SQL, T-SQL, PowerShell, Python, shell scripting, SQL, CLI, REST APIs, and related platform automation tools.
- Strong problem-solving, analytical, decision-making, troubleshooting, and prioritization skills.
- Ability to work independently and collaboratively in a fast-paced, mission-critical environment.
- Effective written and verbal communication, documentation, collaboration, and interpersonal skills.
- Ability to communicate technical architecture, platform risks, capacity requirements, recovery considerations, and cost implications to technical and nontechnical stakeholders.
- Flexibility to provide after-hours and weekend support.
|