| DBA with DB2 & Snowflake-Boston, MA/ Woodbridge, NJ (4 days a week onsite)- Locals at Boston, Massachusetts, USA |
| Email: [email protected] |
| DBA with DB2 & Snowflake-Boston, MA/ Woodbridge, NJ (4 days a week onsite)- Locals i, I hope this email finds you well. My name is Shubham, and I am a Technical Recruiter from Empower Professionals Inc. I came across your profile and wanted to reach out regarding an DBA with DB2 & Snowflake role with one of our clients located at Boston, MA/ Woodbridge, NJ (4 days a week onsite). Please let me know if you are available in the job market and interested in this role (see the job description below) - if so, we can connect and speak further. Local candidates only- Local to NJ/NY or MA Role: DBA with DB2 & Snowflake Location: Boston, MA/ Woodbridge, NJ (4 days a week onsite) Duration: 12+ Months Must have: Good background in db2 database Must have experience with fivetran Senior Database Administrator description: 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, Document DB, 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, Document DB, 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. I would need your updated resume to proceed and can give you a call as soon as I have it. P.S. Empower is a top vendor to clients such as Apex Systems LLC, Sogeti, Randstad, Capgemini, UST and more . Thanks Shubham Technical Recruiter | Empower Professionals [email protected] ...................................................................................................................................... Fax: 732-356-8009 | 100 Franklin Square Drive Suite 104 | Somerset, NJ 08873 www.empowerprofessionals.com Certified NJ and NY Minority Business Enterprise (NMSDC) Shubham Somerset New Jersey, Somerset, NJ 08873 Keywords: access management sthree database information technology microsoft Massachusetts New Jersey New York DBA with DB2 & Snowflake-Boston, MA/ Woodbridge, NJ (4 days a week onsite)- Locals [email protected] |
| [email protected] View all |
| Tue Aug 13 02:13:00 UTC 2024 |