Database Administrator managing AWS RDS, Redshift, and MS SQL Server environments at ACR. Focus on data integrity, performance optimization, and seamless data migrations.
SF
Onsite Lead Database Administrator
Posted 2 weeks ago
About the role
- Lead Database Administrator supporting multiple RDBMS and Snowflake Data Warehouse production. Collaborating with Fidelity Business Units and implementing data analytics strategies in the cloud.
Responsibilities
- 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 to leverage Enterprise Snowflake as part of their data analytics strategy
- Work with product teams, help them in designing & onboarding their warehouse data to Enterprise Datawarehouse Snowflake platform
- 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
- Provide guidance on how to resolve customer-specific technical challenges & work with the snowflake vendor on resolving bugs or any new requirements
- Tune Snowflake for better performance and optimize the utilization of both storage & processing thereby leading to cost efficiency
- Design the monitoring requirements, automate them using python programming & shell scripting
- 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
- Being a Technical SME for Snowflake platform
Requirements
- 5+ years of IT experience
- Relevant experience as Core DBA on Oracle, MS SQL Server or any other RDBMS
- Experience on supporting Snowflake Data Warehouse production platform
- 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
- Knowledge of network policies for securing access (IP whitelisting, private connectivity)
- Familiarity with cloud platforms (AWS, Azure, GCP) and their data services.
- Optional: Exposure to BI tools like Tableau & Power BI
- Designing & implementing High Availability, Disaster Recovery solutions
- Providing Oncall support (12/7), working with vendor on DB issues, bugs & provide solution
Benefits
- Health insurance
- Retirement plans
- Flexible work arrangements
- Professional development opportunities
Job title
Job type
Experience level
Salary
Not specified
Degree requirement
Tech skills
Location requirements
Database Administrator specializing in cloud database management for VSolvit technology services. Implementing operational strategies for MS SQL Server and Azure environments with a focus on security and performance.
Staff Database Administrator managing PostgreSQL databases across global regions for legal AI platform. Driving technical strategy, migration governance, and ensuring database reliability and performance.
Senior Database Administrator managing complex database systems in production for Ouro, a financial services company. Execute performance tuning and automation tasks, ensuring database integrity and performance.
Senior IMS Database Administrator for a Fortune 500 tech company managing IMS and DB2 hosting environments. Seeking candidates with extensive mainframe DBA experience for critical database operations.
Data Architect role within Technopride Ltd, focusing on developing custom application features in Sheffield. Requires extensive banking application experience and robust architectural skills.
Database Administrator managing SAP BRIM and S/4HANA databases for BVA Bears IT Solutions. Ensuring performance, compliance, and collaboration in enterprise database environments.
Senior Database Administrator overseeing RDBMS and NoSQL solutions for Xsolla. Optimizing performance, ensuring high availability, and supporting development teams.
Applications Database Administrator responsible for lifecycle management of enterprise databases at government agency. Requires expertise in Oracle and Microsoft SQL Server for performance and security.
Intermediate Database Administrator supporting systems on various database technologies for asset management firm. Collaborating with developers and data scientists for high - performance data systems.