Database Administrator Specialist

Spectraforce
New York, NY, United States
2 days ago
Apply on leoforce.us
Prepare application

Role details

Contract type
Temporary to permanent
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source

Tech stack

Data Analysis Computing Platforms Backup Devices Client Server Models Command-Line Interface Cloud Computing Databases Information Engineering Oracle Data Guard Disaster Recovery Github Information Management
+24 more
Python (Programming Language) PostgreSQL Microsoft SQL Server Oracle (Applications) Oracle Rac Performance Tuning Windows PowerShell Power BI Recovery Manager (RMAN) Shell Script Software Engineering PL-SQL SQL Databases Transact-SQL Cloud Platform System Oracle Enterprise Manager System Availability Snowflake Microsoft Fabric Infrastructure Automation Frameworks Information Technology Data Management Restful APIs Windows Clustering

Job description

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.

Requirements

  • 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.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on leoforce.us
Prepare application

Good distractions

Loading talks and stories from around this role…