Principal Database Administrator providing DBA support for Oracle, SQL Server and Snowflake data warehouses. Working closely with business units for onboarding data into the Enterprise Datawarehouse Snowflake DB platform.
Responsibilities
Work closely with Fidelity Business Units in onboarding data into Enterprise Datawarehouse Snowflake DB platform (SaaS) & implement security/audit requirements/standards
Define best practices on Snowflake & implement them by closely working with Data Architects & Product Teams
Maintain deep understanding of complex technologies and help business units leverage Enterprise Snowflake as part of their data analytics strategy
Build, design, architect and implement high-volume, high-scale data analytics and machine learning Snowflake solutions in the cloud
Provide technology leadership in driving large complex Snowflake implementations
Tune Snowflake for better performance and optimize utilization of both storage & processing thereby leading to cost efficiency
Understand Data Classification (PII) defined by Information Security Office (ISO) & implement auditing measures to ensure strict controls on data access
Provide snowflake trainings on new features & how they can be leveraged by the product teams
Requirements
12 + years of IT experience
5 + years of experience as Core DBA on Oracle, MS SQL Server or any other RDBMS
3 + years of experience on supporting Snowflake Data Warehouse production platform
3 + years of experience on supporting any databases on public cloud (AWS, Azure)
Proficient in SQL for complex querying, data transformation, and demonstrate expertise in query performance optimization
Deep understanding of Snowflake architecture, including virtual warehouses, micro-partitions, and caching
Hands-on experience with Snowflake account-level management: User and role administration, Resource monitoring, credit usage, Cost optimization and billing insights
Skilled in Snowflake integration with external systems and cloud storage (AWS S3, Azure Blob, GCP)
Expertise in Snowflake Secure Data Sharing setup and management
Experience with Snowflake replication and failover strategies across regions/accounts
Senior leader in database platform engineering driving enterprise data solutions at LPL Financial. Lead infrastructure transformation and establish data architecture strategy for on - prem and hybrid - cloud.
Senior Database Administrator managing PostgreSQL and Oracle databases at Marsh McLennan. Leading complex database migrations and optimizing performance in cloud environments.
Database Administrator managing database environments for Northrop Grumman. Collaborating with a team to achieve high availability and security at Ohio's NASIC facility.
Principal Database Administrator for Northrop Grumman managing databases and supporting modernization efforts at NASIC in Ohio. Requires citizenship and technical expertise in various database systems.
Database Administrator handling database systems for the Teachers’ Retirement System of Illinois. Supporting software development life cycle and providing database administration tasks primarily on SQL Server.
Senior Oracle Database Administrator managing and optimizing mission - critical Oracle database environments. Focusing on performance, resilience, and collaboration with teams in disaster recovery operations.
Database Administrator managing Oracle Primavera P6 databases at Westinghouse. Ensuring data integrity and system availability for project management in the energy sector.
Database Administrator supporting high - visibility mission critical customer at MetroStar. Developing applications and managing database systems with a highly qualified technical team.
Database Administrator managing Oracle Primavera P6 databases, focusing on installation, security, and user support for effective project management solutions at Westinghouse.
Mid/Senior Database Administrator for PostgreSQL at InTTrust. Responsible for database administration and optimization in IT consulting and cloud governance.