Database Administrator Specialist
Spectraforce
New York, NY, United States
2 days ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on leoforce.us
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
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
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦