Cloud Database Engineer in Tampa, FL at Vaco

Date Posted: 2/12/2021

Job Snapshot

Job Description

Functional:

  • Effectively communicate with both technical and non-technical staff as appropriate
  • Efficient in quickly accessing and appropriately escalating technical concerns
  • Provides technical leadership, hands-on implementation skills, and extensive troubleshooting skills for complex cloud and on-prem data systems and day to day IT operations support of operating system and application issues.
  • Participate within the DevOps team with the implementation of CI/CD pipelines and deployments for cloud-based data systems.
  • Responsible for the mentoring and guidance of other Cloud Database Engineers within the team.
  • Partner with IT Engineering and DevOps by providing guidance on alerting metrics and escalation paths for cloud and on-prem data systems.
  • Utilize and demonstrate advanced troubleshooting skills systemically, documentation of issues and working problems proactively out of the environment.
  • Proactively troubleshoots and implements solutions to ensure that all information systems products and services meet organization standards and end-user requirements.
  • Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.
  • Develop and enforce database administration, user standards, and procedures.
  • Establish best practices and policies for installing, configuring, maintaining, and troubleshooting end user access and usage of database applications
  • Develop IT standards and procedures for the organization.
  • Participates in IT Security assessments, risk analysis and reporting
  • Document the company's database environment.
  • Responds to requests for information on IT company policies, practices, guidelines and standards.
  • Design and implement an appropriate database backup and recovery strategy based on data volatility and application availability requirements.
  • Ensure the structural integrity of the databases and that only accurate and appropriate data is entered and maintained in the databases.
  • Proactively monitor the database environment and to make changes to data structures, SQL, application logic or the DBMS subsystem to optimize performance.
  • Ensure data availability using non-disruptive administration tactics.
  • Ensure that only authorized users have access to the data.
  • Assist with predicting growth based on application and data usage patterns and implementing the necessary database changes to accommodate the growth.
  • Responsible for resolving system issues.
  • May provide system or security awareness related training
  • Ensure the safety of Information Systems Assets and to protect systems from intentional or inadvertent access or destruction.
  • Weighs business needs against other concerns and articulates issues to management.
  • Develop and document standard configurations, build and support processes and FAQs.
  • Serves as a liaison or technical resource for others in IT or to partners within other business units.
  • Participate in On-Call rotation for after-hours support and troubleshooting
  • Technical:
  • Ensure overall performance, reliability, stability, and availability of Cloud and on-prem database systems and infrastructure.
  • Lead the configuration, management, and implantation of cloud and on-prem data systems.
  • Perform proactive maintenance, monitoring, and troubleshooting of SQL and all other database systems.
  • Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
  • Create documentation on database recovery and architecture effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related infrastructure.
  • Work to ensure that the associated hardware resources allocated to the databases are configured for high resilience and are tuned for optimum performance.
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes.
  • Identify and partner with developers to remediate inefficient or suboptimal performance of queries, processes, or data structures.
  • Guide complex and critical data/database management initiatives that typically involve multiple disciplines and multiple business groups, including responsibility for database architecture, design, integration, and/or data modeling.
  • Responsible for improvement and maintenance of the databases to include rollout and upgrades.
  • Work with IT Engineering and DevOps to ensure all database systems are backed up in a way that meets the business's Recovery Point Objectives (RPO).
  • Test backups to ensure we can meet the business' Recovery Time Objectives (RTO).
  • Lead architectural decisions for cloud and on-prem data system implementations and upgrades including clustering, log shipping, mirroring, SQL Database servers, Azure SQL Databases, Datalakes, Data Factory, Databricks, or other technologies.
  • Lead the configuration, tuning, and management SQL Always-On Availability Groups.
  • Deploy database change scripts provided by third party vendors.
  • Perform load and execution testing.
  • Develop and deploy methodologies for testing database performance and providing performance statistics and reports.
  • Responsible for assisting developers in creating stored procedures and SQL commands to properly query databases.
  • Continued development of database administration skills; keep abreast of latest techniques, best practices and trends and able to apply to project work.
  • Lead developing SQL queries/scripts and similar artifacts to validate the completeness, integrity and accuracy of data within data load/refresh, backup and recovery processes.
  • Lead in data analysis efforts to resolve complex database performance issues.
  • Lead with the design and development of automated solutions (scripts, functions, programs, processes) to increase the efficiency of the database administration and monitoring processes
  • Document designs and specifications that adhere to company practices.
  • Communicate needs as well as deployment and operations standards to Infrastructure Services.

Support Institutional Initiatives:

  • Keep current on institutional goals, objectives, and progress
  • Engage in institutional sponsored activities and initiatives as appropriate
  • Lead with courage in support of change initiatives that impact organization
  • Manages and assists in coordinating efforts between departments.

Minimum Requirements:

  • Bachelor's degree or equivalent combination of education and experience.
  • 5 years of experience with database design and administration experience with Microsoft SQL Server databases
  • 5 years of experience with Microsoft Azure cloud data services such as Azure SQL Databases, DataLake, DataBricks, SQL Server Stretch Databases, Power BI, and Data Factory.
  • 5 years of experience writing T-SQL and stored procedures and query tuning on high transaction systems.
  • 5 years of experience with Microsoft SQL Server in a high availability environment including Failover Clusters, Availability Groups and Transactional Replication.
  • Possess in-depth SQL knowledge to understand and review SQL and host language programs and to recommend changes for optimization.
  • Proficient experience with SQL Source control tools such as RedGate or VSTS.
  • Advanced working knowledge of SQL, Stored Procedures and SSIS packages.
  • Proficient in Database Administration and Data Replication techniques, processes and best practices and able to provide guidance to other development teams (BI, ETL, Software Engineering, etc.).
  • 3 years of experience leading IT projects including requirements gathering, prioritization, and implementation
  • Ability to prioritize in the face of demanding time frames.
  • Proficient experience with Database monitoring tool sets such as SolarWinds DPA.
  • Proficient experience with Database Modeling and Design Tools (e.g., Erwin, Oracle Designer, ER Studio, etc.).
  • Proficient at collecting, storing, and managing the ability to query the organization's metadata.
  • Ability to translate a data model or logical database design into an actual physical database implementation and to manage that database once it has been implemented.
  • Possess procedural skills to help design, debug, implement, and maintain stored procedures, triggers, and user-defined functions that are stored in the DBMS.
  • Possess understanding of the advanced tenets of relational database technology and be able to accurately communicate them to others.
  • Able to integrate database administration requirements and tasks with general systems management requirements and tasks (such as job scheduling, network management, transaction processing, etc.).
  • Able to professionally communicate fluently in verbal and written English and effectively communicate with all level of the organization
  • Able to work in a team focused environment
  • Excellent customer service mindset and approach
  • Self-motivated; strong work ethic
  • Proficient in MS Office (Word, Excel, PowerPoint) and other business tools such as Skype and Microsoft Teams
  • Able to support a diverse and inclusive work environment