Resiliency and Business Continuity Specialist

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

• 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