Resiliency and Business Continuity Specialist

Resiliency And Business Continuity SpecialistA 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 referencesChart process dependencies, load times and document existing execution schedulesIdentify logical data load completion markers for failover and restartability checkpointsEngage and coordinate with database administrators to baseline and compare production and high availability environmentsEngage and coordinate with windows engineering team to baseline and compare production and high availability environmentsEngage and coordinate with security risk management team to baseline and compare firewall and access configurationsValidate connection configurations, firewall rules and service account access across production and high availability environmentsValidate reconfigured production processes in high availability environmentsPrepare environment specific artifacts with detailed, step-by-step failover triage and recovery instructionsWhat 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 environmentSolid experience working with relational databases like Oracle, SQL Server, Teradata, etc., and interpreting complex SQL queriesSolid experience analyzing and triaging production failuresSolid understanding of change control management and promotion of code to productionSubstantial experience with standing up production (with failover nodes), high availability and disaster recovery environments for database and application serversExperience with data integration and reporting tools like Informatica, SSIS, SSRS, Talend and procedural codingGood knowledge of database design, documentation and codingGood knowledge of data warehouse methodologies and best practicesStrong problem solving skills, with an analytical mindsetBS degree in Computer Science or relevant experience in lieu of a college degree for exceptional candidatesKnowledge of working within Agile framework is desiredComplimentary skill sets like background in Java, scripting languages, etc., will be a huge bonus