This site uses cookies. To find out more, see our Cookies Policy

Database Administrator-Direct Hire - $85k - Tampa, FL in Tampa, FL at Vaco

Date Posted: 11/9/2018

Job Snapshot

Job Description

Purpose of the Position

The Database Administrator I role is responsible for administering Microsoft SQL Server and SQL databases and managing the security, integrity and performance of the databases. This position will offer the ideal candidate an opportunity to learn and grow professionally and technically while contributing to the overall Enterprise Data Management effort. This candidate will need to have either relevant educational training and/or at least 3 - 5 years of professional experience doing database administration work.

Primary Duties and Responsibilities

Technical Responsibilities
  • Work with the Senior Database Administrator to ensure overall performance, reliability, stability, and availability of database systems and infrastructure. Will assist with the proactive maintenance, monitoring, and troubleshooting of all database systems.
  • Create documentation on database recovery and architecture effective provisioning, installation/configuration, operation, and maintenance of systems hardware and software and related infrastructure.
  • Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.
  • 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.
  • Assist with 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 troubleshooting and problem solving of SQL and other database systems.
  • Responsible for improvement and maintenance of the databases to include rollout and upgrades.
  • Work with Infrastructure to ensure all database servers are backed up in a way that meets the business's Recovery Point Objectives (RPO).
  • Assist with testing backups to ensure we can meet the business' Recovery Time Objectives (RTO).
  • Troubleshoot SQL Server service outages as they occur, including after-hours and weekends.
  • As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies.
  • Configure, tune, and manage SQL AlwaysOn Availability Groups.
  • Deploy database change scripts provided by third party vendors.
  • Perform load and execution testing.
  • Document the company's database environment.
  • Strong working knowledge of SQL, Stored Procedures and SSIS packages.
  • Develop and deploy methodologies for testing database performance and providing performance statistics and reports.
  • Work with Senior Database Administrator to establish best practices and policies for installing, configuring, maintaining, and troubleshooting end user access and usage of database applications
  • On-call availability for after hours, as needed.
  • Overtime hours may be required to meet project deadlines.
  • Assist with developing and enforcing database administration and user standards and procedures.
  • Responsible for assisting developers in creating stored procedures and SQL commands to properly query databases.
Managing People and Teams
  • Conduct knowledge exchange sessions with the BI, Software Engineering and the EDM teams.
  • Work with developers to address complicated data access requirements and to resolve complex application data issues.
  • Work with Senior Database Administrator to define and deliver consistent database administration standards, methodologies, guidelines and techniques.
  • Ensure compliance to standards through code walkthroughs and metadata reports.

(For each item, indicate required or preferred)
  • BS or BA in computer science or equivalent education and experience (required).
  • 3 - 5 years of database design and administration experience with Microsoft SQL Server databases (required).
  • One or more certifications for Microsoft SQL Server 2012, 2014 and 2016 (required).
  • Experience in High Availability technologies including Failover Clusters, Availability Groups and Transactional Replication (preferred).
  • 3 - 5 years of experience in data warehouse concepts, practices, and procedures (preferred).
  • 3 - 5 years of experience with ETL tools or ETL programming (required).
  • Proficient experience writing T-SQL and stored procedures and query tuning on high transaction systems (required).
  • Technical, hands-on experience implementing data warehouse solutions (preferred).
  • Experience with relational database concepts (required), service-oriented architecture (SOA), ESB, and portal technologies (preferred).
  • 3 - 5 years of experience with IT projects and information development (required).
  • Proficient experience with Database Modeling and Design Tools (e.g., Erwin, Oracle Designer, ER Studio, etc.) (required).
  • Proficient experience with the Microsoft development environment (Visual Studio, Team Foundation Server) (required).
  • Proficient experience with RedGate SQL tools and other SQL Source control tools (required).
  • Knowledge of other databases like Oracle and cloud-based solutions like Azure (preferred)