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