Mandatory knowledge-set includes full life-cycle experience migrating complex business application from Oracle to Postgress (and/or Aurora) in On Prem as well as in AWS
AWS architecture or development experience required
Develops , manage and setup data, data collection , aggregation, and other strategies that optimize system efficiency and responses.
Monitors performance and quality control plans to identify performance
Works on problems of moderate to highly complex where analysis of data may require adaptation of starndardized practices utilizing all open source tools for presentation layer and datawarehouse solution.
Ability to manage multiple assignments. Superior written and oral communication skills. 6+ years of experience.
Candidate will be responsible for architecting, setting up , analyzing, developing PL SQL and migrating complex business application from Oracle (Cluster and GG enabled) to Postgress (and/or Aurora) On Prem as well as in AWS.
Candidate will also be responsible for documentation of migration process, cross- training and turnover to in-house support team. Resource will be held accountable for providing story point/ LOE estimates, and strict adherence to deadlines.
Requires Agile development experience, working in Sprint cadence within Jira. Will work directly with onshore in-house development management and team, with close interaction with offshore vendor migration support. Requires Agile development experience, working in Sprint cadence within Jira. Will require early morning (8am est) daily standup calls with offshore team.
Capable to write medium to complex level SQL query to fetch and construct data that can be utilized for data analysis and presentation layer - working with various tools like Spark, Sqoop, if needed.
MUST HAVE SKILLS:
-Strong skills on Postgress, Oracle RAC/Cluster, Oracle Golden Gate, No SQL(Cassandra, Mongo)
-PostgreSQL Database Technical skill set requirements include:
• PL/pgSQL, views, sequences, functions, T-SQL
• Stored procedures, functions, constraints, joins, subqueries, triggers, and CTEs.
• ETL experience a plus, specifically with SPARK, HADOOP
• Experience with development tools like Jira, GitHub, RedGate, and Aurora PostgreSQL migration tools like AWS SCT. Fluent in IT and Data security compliance.
• Experience in post-migration performance tuning and analysis, along with CloudWatch alert setup and logging.
- UNIX OS and AWS monitoring tool
Spark, Snowflake, Cassandra, Mongo, ETL job process
Apply now to have the opportunity to be considered for similar jobs at leading companies in the Seen network for FREE.
Zero stress and one profile that can connect you directly to 1000s of companies.
We’ll take it from there. After you tell us what you’re looking for, we’ll show you off to matches.
Boost your interview skills, map your tech career and seal the deal with 1:1 career coaching.
Join now and Be Seen.