Senior Database Architect / DBA
hace 3 días
New York
About the Company • Investment firm located in Midtown NYC About the Role • Own the architecture, planning, design, development, implementation, administration, governance, and maintenance of the firm’s databases and data platforms, • Support cloud-based, distributed, and client/server environments, • Core platforms: Oracle, SQL Server, Microsoft Fabric, Snowflake, and PostgreSQL Position Details • Location: Midtown NYC, • Employment type: Right to hire, • Must be a US Citizen or GC holder since the client is not willing to sponsor visa now or in the future Pay • Up to $75 per hour. W2 only, no C2C Responsibilities • Architect, implement, administer, and support enterprise Oracle environments (RAC, Data Guard, RMAN, Oracle Enterprise Manager, partitioning, Diagnostics and Tuning Packs, performance tuning, backup and recovery, HA, and DR), • Architect, implement, administer, and support enterprise SQL Server environments (Availability Groups, Windows Clustering, performance tuning, backup and recovery, security, monitoring, HA, and DR), • Architect, implement, administer, and support Microsoft Fabric, Power BI, Snowflake, and Postgres (CLI, REST API, Capacity Metrics app, GitHub Actions, OneLake, SnowSQL), • Collaborate with application development, data engineering, analytics, infrastructure, security, compliance, and business teams, • Analyze usage patterns, workload growth, storage consumption, and capacity demand to optimize performance, availability, and cost, • Lead initiatives to improve operational efficiency, reliability, scalability, observability, and automation, • Develop and maintain architecture documentation, operational standards, monitoring procedures, recovery runbooks, capacity plans, and security standards, • Research and evaluate emerging database, cloud, analytics, and Microsoft Fabric technologies, • Provide production support and take part in incident response, root-cause analysis, change management, DR testing, migrations, upgrades, and platform deployments Required Skills and Qualifications • 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 in large-scale, mission-critical production environments, • Extensive hands-on experience with Oracle RAC, Data Guard, RMAN, Oracle Enterprise Manager, partitioning, Diagnostics and Tuning Packs, PL/SQL, SQL Server Availability Groups, Windows Clustering, security, Fabric CLI, Admin Portal, and Capacity Metrics app, • Scripting and automation experience with PL/SQL, T-SQL, PowerShell, Python, shell scripting, SQL, CLI, and REST APIs, • Strong problem-solving, analytical, decision-making, troubleshooting, and prioritization skills, • Ability to work independently and collaboratively in a fast-paced, mission-critical environment, • Strong written and verbal communication and documentation skills, • Ability to explain technical architecture, platform risks, capacity needs, recovery considerations, and cost implications to technical and nontechnical stakeholders, • Flexibility to provide after-hours and weekend support