Senior Database/Data Engineer

• 
  Develop innovation, strategies, processes, and best practices.
• Analyze and organize raw data
• Help build data systems and pipelines
• Evaluate business needs and objectives
• Interpret trends and patterns
• Conduct complex data analysis and report on results
• Prepare data for prescriptive and predictive modeling
• Build algorithms and prototypes
• Ensures all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO).
• Tests backups to ensure we can meet the business’ Recovery Time Objectives (RTO).
• Provides database support for Release Management cycles and Acquisition efforts.
• Monitors and maintains Dev/Test/Prod environments.
• Facilitating creation of a replicated architecture, providing database tuning and monitoring database security, performance and utilization
• Troubleshoots SQL Server problems
• Configures SQL Server monitoring utilities to alert on potential problems.
• Installs and configures new SQL Servers and refresh existing SQL Servers according to best practices. Ideally designing an unattended install script that applies all configurations.
• Must work in coordination with developers in order to meet the needs and specifications of the project and document all the procedures in a concise manner.
• Deploys database change scripts provided by third party vendors & in-house development teams.
• When performance issues arise, analyzes queries or statements in question and determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
• Reviews SQL for application and development staff to ensure coding efficiency.
• Documents the company’s database environment.
• Maintains user permissions at appropriate levels and reviews quarterly
• Documents and applies database security standards across all database environments (development through production).
• Stays current with the latest technology (i.e., Azure SQL PaaS, SQL Server 2012+, SSIS, SSRS, SSAS) and act as a key player in recommending new ways to utilize technology for the benefit of the organization.
• Cloud Database Management and Design. Must understand dataflow thru Azure Data Lake, Azure SQL PaaS, connections via Azure Key Vault.
• Database Security & Encryption
• Cognisent of bandwidth issue on a Hybrid Cloud Configuartion.
• Create transactional based replication from On-Premise to Cloud Databases.
• Interface with Micrsoft Github, Jira, TFS, etc.
• Assists with SSIS and SSRS development projects as time allows.
• Understanding of, and experience with, maintaining OLTP databases with 99.9% uptime requirement in physical and virtual (VMWare) deployment models.
• Stays in touch with the community to be aware of tools made available through the community.

Required Skills:

• Able to work well in an atmosphere of teamwork, collaboration and empowerment. This position involves extensive interaction with customers, which may cross numerous business departments, as well as vendors and contractors.
• Excellent oral and written communication skills.
• Applicable learning skills.
• Successful problem solving and analysis.
• Effective stress tolerance.
• Capable of working individually and co-operatively as part of a team.
• Customer service oriented with the ability for developing long lasting relationships with internal and external business partners.

Organizational:

• Develops creative ideas and solutions to real time business problems and/or business opportunities; takes reasonable, calculated risks even if failure is possible.
• Empowers self and teammates to continuously improve RiverStone’s business processes/ systems and develops and escalates ideas and solutions.
• Consistently delivers superior customer service to both internal and external business partners.
• Demonstrates alignment with RiverStone’s Commitments.
• Prioritizes and organizes work in self-directed manner.
• Attains and maintains knowledge of assigned department.
• Performs other duties as required, including supporting and coordinating with other department colleagues.

Four-year college degree in Computer Science or related field.

Additional equivalent years of experience in Information Technology can be substituted for degree.

This position operates in a professional cubicle based collaborative environment and must have the ability to timely produce thorough, accurate work with many competing demands, deadlines, and distractions. The position uses standard equipment such as phones, computers, copiers/printers and filing cabinets. Noise level is moderate. While this is a largely sedentary role, the employee is regularly required to talk or hear; stand; walk; bend; use hands to handle or feel; and reach with hands and arms. On occasion the individual must be able to lift and transport boxes weighing up to 30 pounds.

Other Duties (Disclaimer Statement)

RiverStone retains the right to change or assign other duties to this position as needed, OR

Other duties or responsibilities may change or be assigned as needed.

Learning on the Fly: Learns quickly when facing new problems; a relentless and versatile learner; open to change; analyzes both successes and failures for clues to improvement; experiments and will try anything to find solutions; enjoys the challenge of unfamiliar tasks; quickly grasps the essence and the underlying structure of anything.

Problem Solving: Uses rigorous logic and methods to solve difficult problems with effective solutions; probes all fruitful sources for answers; can see hidden problems; is excellent at honest analysis; looks beyond the obvious and doesn’t stop at the first answers.

Process Management: Good at figuring out the processes necessary to get things done; knows how to organize people and activities; understands how to separate and combine tasks into efficient flow; knows what to measure and how to measure it; can see opportunities for synergy and integration where others can’t; can simplify complex processes; gets more out of fewer resources.

Sizing Up People: Is a good judge of talent; after reasonable exposure, can articulate the strengths and limitations of people inside or outside the organization; can accurately project what people are likely to do across a variety of situations.

Ethics and Values: Adheres to an appropriate( for the setting) and effective set of core values and beliefs during both good and bad times; acts in line with those values; rewards the right values and disapproves of others; practices what he/she preaches.