Senior Database Administrator

6 days ago

Woodbridge, NJ, United States RIT Solutions, Inc. Full time

Title- Senior Database Administrator
Client- Plymouth Rock Assurance
Location-Woodbridge, NJ or Boston, MA

Must have - Snowflake, DB2, DBT, 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 vi 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.

  • Senior Database Administrator- DB2 DBA

    2 days ago

    Woodbridge, NJ, United States Equiliem Full time

    Position: Senior Database Administrator-DB2 DBA Location: Boston, MA or Woodbridge, NJ-Onsite Senior level role - 13+ years Need to go Inperson interview for final round ***MUST BE A STRONG DB2 DBA WITH SNOWFLAKE EXPERIENCE Immediate need for DBA to join the client's database administrator team. You will serve an integral part in assisting with the...

  • Senior Database Administrator- DB2 DBA

    1 week ago

    Woodbridge, NJ, United States Equiliem Full time

    Position: Senior Database Administrator-DB2 DBA Location: Boston, MA or Woodbridge, NJ-Onsite Senior level role - 13+ years Need to go Inperson interview for final round ***MUST BE A STRONG DB2 DBA WITH SNOWFLAKE EXPERIENCE Immediate need for DBA to join the client's database administrator team. You will serve an integral part in assisting with the...

  • Senior .NET Web API Developer

    1 week ago

    Woodbridge, NJ, United States Kaav Inc. Full time

    Job Title / Posted Title Senior .NET Web API Developer Opening / Selling Statement Seeking a Senior .NET Web API Developer to become a member of a newly formed project team. Financial services client has a legacy application that manages and maintains employee records. The legacy application technology platform has outlived its useful lifespan and needs a...

  • Senior .NET Web API Developer

    2 days ago

    Woodbridge, NJ, United States Kaav Inc. Full time

    Job Title / Posted Title Senior .NET Web API Developer Opening / Selling Statement Seeking a Senior .NET Web API Developer to become a member of a newly formed project team. Financial services client has a legacy application that manages and maintains employee records. The legacy application technology platform has outlived its useful lifespan and needs a...

  • Senior WordPress developer

    4 days ago

    Woodbridge, NJ, United States ShiftCode Analytics Full time

    Interview: F2F (not negotiable) Visa: USC and GC Hybrid: 581 Main St, Woodbridge Township, NJ 07095 Please review your candidate profiles and talk to the candidates to make sure they match the profile. Please send us consolidated list of candidate profiles. Also, in addition to technical expertise the candidates need to have strong communication and...

  • Senior WordPress developer

    2 weeks ago

    Woodbridge, NJ, United States ShiftCode Analytics Full time

    Interview: F2F (not negotiable) Visa: USC and GC Hybrid: 581 Main St, Woodbridge Township, NJ 07095 Please review your candidate profiles and talk to the candidates to make sure they match the profile. Please send us consolidated list of candidate profiles. Also, in addition to technical expertise the candidates need to have strong communication and...

  • Senior WordPress developer

    1 week ago

    Woodbridge, NJ, United States ShiftCode Analytics Full time

    Interview: F2F (not negotiable) Visa: USC and GC Hybrid: 581 Main St, Woodbridge Township, NJ 07095 Please review your candidate profiles and talk to the candidates to make sure they match the profile. Please send us consolidated list of candidate profiles. Also, in addition to technical expertise the candidates need to have strong communication and...

  • Senior WordPress developer

    2 hours ago

    Woodbridge, NJ, United States ShiftCode Analytics Full time

    Interview: F2F (not negotiable) Visa: USC and GC Hybrid: 581 Main St, Woodbridge Township, NJ 07095 Please review your candidate profiles and talk to the candidates to make sure they match the profile. Please send us consolidated list of candidate profiles. Also, in addition to technical expertise the candidates need to have strong communication and...

  • Senior Client Services Coordinator

    4 days ago

    Woodbridge, NJ, United States Colliers International Full time

    Make your next move an expert one. At Colliers it's not our success that sets us apart, it's how we achieve it. Our people are passionate, take ownership and always do what's right for our clients, people and communities. Why Colliers? Our enterprising environment needs your expertise to facilitate Colliers' continued growth as an industry leader. Our...

  • Senior Client Services Coordinator

    4 days ago

    Woodbridge, NJ, United States Colliers Full time

    Make your next move an expert one. At Colliers it's not our success that sets us apart, it's how we achieve it. Our people are passionate, take ownership and always do what's right for our clients, people and communities. Why Colliers? Our enterprising environment needs your expertise to facilitate Colliers' continued growth as an industry leader. Our...