PatersonRecruiter Since 2001
the smart solution for Paterson jobs

Sr. Database Migration Architect

Company: Capstone Integrated Solutions
Location: Chester
Posted on: February 24, 2021

Job Description:

Sr. Database Migration ArchitectIf you are passionate about Digital Transformation and helping businesses accelerate their migration to the cloud, Capstone Integrated Solutions would like to meet with you. We are looking for an experienced Database Migration Architect to design and develop strategies to migrate and modernize our clients technology landscapes as they shift from on premise to the AWS cloud.
Responsibilities:

  • Participate in design and implement AWS RDS, Aurora and/or Redshift architectures and configurations for customer
  • Think strategically about business, product, and technical challenges in an enterprise environment
  • Analyze on premise transactional database environments such as Oracle, SQL Server, MySQL and/or Postgres, evaluate and plan migrations to cloud
  • Participate in architectural discussions and design exercises to create large scale solutions built on AWS and also be part of the development lifecycle.
  • Identify workarounds for specific issues and corner scenarios observed during migration
  • Automate solutions for repeatable problems
  • Develop test plan to demonstrate application/database readiness post migration
  • Consult for optimal design of database environments, analyzing complex distributed production deployments, and making recommendations to optimize performance
    Qualifications:
    • 10+ years of experience in a technical position working for enterprise customers
    • 8+ years of experience in database development/migration using PL/pgSQL
    • 3+ years of experience with AWS Cloud
    • 3+ years hands-on experience on PostgreSQL
    • Proven expertise on architecture patterns and continuous improvement
    • High end Troubleshooting and Communication skills
    • Experience with databases of 1-10TB in size across multiple database platforms (e.g. PostgreSQL, Oracle, SQL Server, MySQL, MariaDB, etc.)
    • Experience in non-relational databases - DynamoDB, Mongo, etc.
    • Experience with heterogenous database migrations from one database engine to another
    • Experience in performance optimization techniques
    • Scripting language (bash, Perl, python, Java)
    • Experience in Database Administration - backup/restore, replication, etc.
    • Experience in writing procedural language artifacts: PL/SQL, T-SQL, PL/pgSQL, stored procedures
    • Experience in Data Modelling, ETL/ELT workflow management desired & ability to write, tune SQL queries desired
    • Experience in MPP data warehouse solutions - Redshift, Greenplum, etc.
    • Bachelor's degree in Computer science or equivalentPreferred Qualifications:
      • Integration of cloud services with on-premise technologies from Microsoft, IBM, Oracle, HP, SAP etc.
      • Industry Cloud Certification(s) such as AWS Certified Solutions Architect, AWS Certified SysOps Administrator, AWS Certified DevOps Engineer, AWS Certified Database- Specialty

        Qualifying Questions:
        • Do you have AWS Certifications?
        • Answer needs to be Yes
        • Do you have experience leading a team from design through delivery of both Oracle and SQL Server migrations to the AWS Cloud?
        • Answer should be yes (Oracle, SQL, Amazon Cloud, and design through delivery)
        • What's the sale of the largest migration you took part in (# Databases and size of databases) and what role did you play on that project?
        • Answer should reflect large scale (100s to 1000s of DBs some ranging in size from 1-10TB of data)

Keywords: Capstone Integrated Solutions, Paterson , Sr. Database Migration Architect, IT / Software / Systems , Chester, New Jersey

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Senior Java Developer - 1324
Description: Senior Java Developer - Transfer your visa - 1324 br br -- br br Location: 100 REMOTE--during Covid work from home then onsite in Hoboken, NY br Position Type: Full-time with benefits - (more...)
Company: PlacingIT
Location: Hoboken
Posted on: 02/28/2021

Trigonometry Private Tutoring Jobs Mobile
Description: CompanyWe are looking for students, professionals, retirees or anyone with a passion to share, to join the largest community of teachers worldwide If you have free time and want to share your knowledge, (more...)
Company: superprof
Location: White Plains
Posted on: 02/28/2021

SQL Server DBA
Description: Bachelor's degree or equivalent work experience.Minimum 7 years' experience with database administration for MSSQL Server 2014 and up Minimum 3 years of SQL server database
Company: Aquinas Consulting
Location: White Plains
Posted on: 02/28/2021


UI EXT.JS Developer
Description: Position: UI EXT.JS Sencha DeveloperLocation: New Brunswick, NJDuration: 12 months with extensions Responsibilities: ul li Conduct testing of completed applications, websites, and software to Assess (more...)
Company: Evoke Technologies
Location: New Brunswick
Posted on: 02/28/2021

Academic English Private Tutoring Jobs Mobile
Description: CompanyWe are looking for students, professionals, retirees or anyone with a passion to share, to join the largest community of teachers worldwide If you have free time and want to share your knowledge, (more...)
Company: superprof
Location: White Plains
Posted on: 02/28/2021

SAP Quality Management consultant
Description: TSR is a premier National U.S. Staffing company with over 50 years of staffing excellence. Our client, a leading Pharmaceutical company is hiring a SAP Quality Management consultant on a Contract basis. (more...)
Company: TSR Consulting Services, Inc
Location: New Brunswick
Posted on: 02/28/2021

Field Service Technician can be located in NJ/PA, Columbus, OH and Houston, TX
Description: Description Summary Field Service Technicians serve their customers by providing preventative maintenance fluid, filters, inspection , repairs anything from tightening a bolt to replacing an engine (more...)
Company: Hudson RPO
Location: New Brunswick
Posted on: 02/28/2021

Private Tutoring Jobs Mobile
Description: CompanyWe are looking for students, professionals, retirees or anyone with a passion to share, to join the largest community of teachers worldwide If you have free time and want to share your knowledge, (more...)
Company: superprof
Location: White Plains
Posted on: 02/28/2021

Spanish Private Tutoring Jobs Mobile
Description: CompanyWe are looking for students, professionals, retirees or anyone with a passion to share, to join the largest community of teachers worldwide If you have free time and want to share your knowledge, (more...)
Company: superprof
Location: White Plains
Posted on: 02/28/2021

In-Home Usage Tester (Product Tester from home) Part-time
Description: American Consumer Panels reg , located at One World Trade Center, 285 Fulton St., Suite 8500 New York, NY, 10007, is looking to fill the position listed below nationwide : br br In-Home Usage Tester (more...)
Company: American Consumer Panels
Location: White Plains
Posted on: 02/28/2021

Log In or Create An Account

Get the latest New Jersey jobs by following @recnetNJ on Twitter!

Paterson RSS job feeds