Resiliency and Business Continuity Specialist

What we would like to see :

A meticulous, well organized self-starter who has significant experience working in a large scale implementation of databases or applications with database backends. Candidates with knowledge of data warehousing technologies are highly desired.

You should also have decent experience with IT systems, software development techniques and supporting production events. Since you will be working closely with various infrastructure and enterprise risk management team members, we expect you to clearly articulate the requirements and create detailed artifacts for audit purposes.

A typical day as a Resiliency and Business Continuity Specialist :

• Create and maintain inventory of all production processes, source and target systems, and connection references
• Chart process dependencies, load times and document existing execution schedules
• Identify logical data load completion markers for failover and restartability checkpoints
• Engage and coordinate with database administrators to baseline and compare production and high availability environments
• Engage and coordinate with windows engineering team to baseline and compare production and high availability environments
• Engage and coordinate with security risk management team to baseline and compare firewall and access configurations
• Validate connection configurations, firewall rules and service account access across production and high availability environments
• Validate reconfigured production processes in high availability environments
• Prepare environment specific artifacts with detailed, step-by-step failover triage and recovery instructions

What you will need to bring to the table :

5+ years experience of working as a production support specialist or an ETL developer or an application development role in a large enterprise data warehouse environment

Solid experience working with relational databases like Oracle, SQL Server, Teradata, etc., and interpreting complex SQL queries

Solid experience analyzing and triaging production failures

Solid understanding of change control management and promotion of code to production

Substantial experience with standing up production (with failover nodes), high availability and disaster recovery environments for database and application servers

Experience with data integration and reporting tools like Informatica, SSIS, SSRS, Talend and procedural coding

Good knowledge of database design, documentation and coding

Good knowledge of data warehouse methodologies and best practices

Strong problem solving skills, with an analytical mindset

BS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidates

Knowledge of working within Agile framework is desired

Complimentary skill sets like background in Java, scripting languages, etc., will be a huge bonus