Snowflake Database Administrator
1 month ago
This position can sit in either Woodbridge, NJ or Boston, MA (4 days/week onsite)
Must Haves:
Snowflake
DB2
FiveTran
Senior Database Administrator
As a senior member of a skilled database administrator team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran HVR Replication Tool, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also include cross-functional collaboration with software development, security, and data warehouse teams. Production on-call support, maintenance, and off-hour deployments are required.
Essential Functions and Responsibilities:
- Maintain a Snowflake data warehouse, and data replication from various sources.
This will include production deployments via a dev/ops procedure as well as monitoring
the health and well-being of the environment.
- Set up and maintain security and access for production.
- Development responsibilities include data modeling and analysis, schema design, and database object creations (tables, stored-procedures, triggers, functions, and jobs, etc.)
- Identify, assess, and evaluate technologies, products, and tools for building enterprise architecture services
- Analyze archiving approaches, propose solution(s) and assist in implementation of chosen approach
- Review and revise existing tables and indexing strategies to improve storage efficiency and access
- Responsible for performance tuning assistance on all data pull/queries and working with end-users
- Pro-actively identify issues and coordinate resolutions
- Assist programmers during development by responding to questions and providing guidance when necessary.
- Responsible for user direction/support on all data queries
- Analyze problems and propose, present and propagate solutions or practices to meet architectural challenges
- Participating in unit, system, user and performance testing
- User level familiarity with version control tools
- Installation, maintenance, and on-call support
- Qualifications and Education:
- Working experience in setup, integration, and security [Active Directory/SSO etc.] with any
- SAAS applications
- Knowledge & ideally working experience, data lake, data modelling on Snowflake, AWS S3, Glue
- Working experience in setting up security and access controls in Snowflake
- 5+ years hands on database work DB2/UDB, SQL Server
- Hands on experience with AWS RDS, DocumentDB, DynamoDB, and Redis databases
- An understanding of proper indexing and experience with query tuning
- Knowledge of DB2
- Knowledge of UDB/AIX utilities such as backup, reorg, runstats and rebind is required
- Knowledge of Oracle and MS SQL Server reorg, update stats
- Experience with AWS DMS
- Excellent communication (verbal and written) and interpersonal skills
- Experience using a Software Development Life Cycle (SDLC) methodology
- Ability to analyze existing configuration and recommend hardware/software improvements
- Demonstrated ability to meet business needs with sound technical approaches
- Self-motivated, task oriented, and capable of working independently on multiple projects simultaneously
- Knowledge of the Property and Casualty Insurance industry is a plus
- Knowledge of replication desired.
- Prior experience migrating databases from on premise data center to the cloud is preferred.
-
Snowflake Database Administrator
1 month ago
Woodbridge, United States firstPRO, Inc Full timeThis position can sit in either Woodbridge, NJ or Boston, MA (4 days/week onsite)Must Haves:SnowflakeDB2FiveTranSenior Database AdministratorAs a senior member of a skilled database administrator team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran...
-
Senior Database Administrator
3 months ago
Woodbridge Township, United States Plymouth Rock Assurance Full timeSenior Database Administrator As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also...
-
Senior Database Administrator
3 months ago
Woodbridge, United States Plymouth Rock Assurance Full timeSenior Database Administrator As a senior member of a skilled database team, you will serve an integral part in assisting with the migration, maintenance, update, and support of various database platforms including Snowflake, Fivetran, DBT, DB2, Oracle, SQL Server, AWS RDS, Redis, DocumentDB, DynamoDB, and Data Migration Service (DMS). Activities will also...
-
Senior Database Architect
2 days ago
Woodbridge, New Jersey, United States Plymouth Rock Assurance Full timeAbout the RoleWe are seeking a highly skilled Senior Database Administrator to join our team at Plymouth Rock Assurance. As a senior member of our database team, you will play a critical role in the migration, maintenance, update, and support of various database platforms.Key ResponsibilitiesDatabase Management: Maintain a Snowflake data warehouse, and data...
-
Database Administrator
1 month ago
Ohio Township, United States SmartIPlace Full timeJob DescriptionJob DescriptionRole: Database AdministratorLocation: Fully remote Prefer Ohio must be on EST Columbus, OhioDuration: +12 Month contract PART TIME - We need them to build multiple reports. They can work their own hours to build them.Visa: All Visa Except TN and CPTClient: State of OhioInterview: VideoDescription:Project: Sunset MainframeSkills:...
-
SQL Database Administrator
1 month ago
Van Buren Charter Township, United States Predica Inc Full timeDescription:Client is looking for a SQL DBA with 2-5 years of experience to join their data platforms team (10 people on the team) as they strive to become more of a data-driven organization. Embarking on a large-scale migration to Azure, they are creating their strategy and identifying opportunities to consolidate databases as they migrate. This SQL DBA...
-
Senior Data Modeler
2 weeks ago
Woodbridge, United States RIT Solutions, Inc. Full timeNot a traditional Data Analyst role. Looking for someone who has strong data modelling, relational, physical and logical data modelling concepts. Working with business create physical model and implement Snowflake. Strong experience with Creation of complex conceptual modelling. Experience with ESG Experience with Snowflake is huge plus. Mostly remote...
-
Carrier Credentials Systems Analyst
1 month ago
Woodbridge Township, United States World Insurance Associates LLC Full timeAbout UsWorld Insurance Associates is a unique insurance and professional services organization offering top products and services from major providers, combined with attentive service from local agents.Founded in 2011, World is the second fastest-growing insurance broker in the U.S. We specialize in personal and commercial insurance lines, surety and...
-
Carrier Credentials Systems Analyst
4 weeks ago
Woodbridge Township, United States World Insurance Associates LLC Full timeAbout UsWorld Insurance Associates is a unique insurance and professional services organization offering top products and services from major providers, combined with attentive service from local agents.Founded in 2011, World is the second fastest-growing insurance broker in the U.S. We specialize in personal and commercial insurance lines, surety and...
-
Public Cloud Database PaaS Engineer
3 months ago
Mount Laurel Township, United States Highbrow LLC Full timeJob Responsibilities: Be responsible for the solution engineering, design, optimization, integration, automation, and maintenance of popular Google Cloud Platform (GCP) and Microsoft Azure (AZ) database PaaS services, such as Microsoft SQL Server, PostgreSQL, No-SQL and Redis. Provide R&D for introducing public cloud PaaS to TD environment, DevOps...
-
Sr. SharePoint Developer
1 week ago
Woodbridge Township, United States ASB Resources Full timeWe are looking for a skilled SharePoint Developer who has experience in designing, implementing, and maintaining SharePoint sites and solutions. The ideal candidate will also have a solid understanding of SQL databases and be able to integrate SharePoint with SQL data sources effectively.Responsibilities:Design, develop, and implement SharePoint solutions,...
-
Woodbridge, Virginia, United States Prince William County, VA Full timeAbout the Role:Prince William County, VA is seeking a highly motivated individual to fill the position of Domestic Violence Program Manager/Administrative Support Supervisor. This role will be responsible for managing the day-to-day operations of two agency divisions, including the Protective Order Monitoring Program and Administrative Support Staff.Key...
-
Real Estate Paralegal
6 days ago
Woodbridge Township, United States Bernard Nickels & Associates Full timeWe are a dynamic leader in the real estate development industry, specializing in acquiring, developing, and managing multi-family residential properties. We are seeking a highly motivated and detail-oriented Paralegal to join our in-house legal team. The primary responsibility of this role is to coordinate multi-family residential loan transactions, ensuring...
-
Tech Lead- Devops
1 week ago
Missouri Township, United States PROCYON TECHNOSTRUCTURE Full timeJob DescriptionJob DescriptionAbout Us:At Tech Mahindra (Tech Mahindra | Connected World, Connected Experiences), we live the philosophy of connected world and connected experiences. We thrive on change that is powered by the intelligent symphony of technology and humans designing meaningful and sustainable experiences. Consumer 'experiences' are...
-
Purchasing Administrator
1 month ago
West Bloomfield Township, United States Grip Full timeDo you want to work for a company that’s growing, innovating, and trying new things? If so then you that is is exactly what we do here. We are looking for a Purchasing Administrator to join our growing team.GRIP is a full service, multi-state cannabis company. We do business in every aspect of the industry including real estate, licensing, owning and...
-
Purchasing Administrator
1 month ago
West Bloomfield Township, United States Grip Full timeDo you want to work for a company that’s growing, innovating, and trying new things? If so then you that is is exactly what we do here. We are looking for a Purchasing Administrator to join our growing team.GRIP is a full service, multi-state cannabis company. We do business in every aspect of the industry including real estate, licensing, owning and...
-
Systems Administrator
3 months ago
Rockaway Township, United States Link Solutions, Inc. Full timeJob DescriptionLink Solutions is seeking a Systems Administrator to join our team in Picatinny Arsenal, NJ.Must be a U.S. Citizen DoD Secret Security ClearanceThe Systems Administrator will be responsible for system administration, engineering effort, and providing maintenance and sustainment for existing and new government IT systems. In this role, you...
-
Senior Paralegal
1 week ago
Woodbridge Township, United States World Insurance Associates LLC Full timePosition SummaryAs part of a rapidly growing company, focused on building world class operations and corporate culture, support the Compliance and Legal department in regulatory, compliance and operational matters. Responsible for coordinating numerous leaning management systems, databases and tracking systems. Liaison to departmental business teams. Perfect...
-
Insurance Senior Paralegal
1 day ago
Woodbridge Township, United States World Insurance Associates LLC Full timePosition SummaryAs part of a rapidly growing company, focused on building world class operations and corporate culture, support the Compliance and Legal department in regulatory, compliance and operational matters. Responsible for coordinating numerous learning management systems, databases and tracking systems. Liaison to departmental business teams....
-
Insurance Senior Paralegal
3 days ago
Woodbridge Township, United States World Insurance Associates LLC Full timePosition SummaryAs part of a rapidly growing company, focused on building world class operations and corporate culture, support the Compliance and Legal department in regulatory, compliance and operational matters. Responsible for coordinating numerous learning management systems, databases and tracking systems. Liaison to departmental business teams....