Previous Job
Previous
Team Lead, Database Administration
Ref No.: 17-07198
Location: Boston, Massachusetts
Position Type:Direct Placement
Start Date: 08/08/2017
My client has an immediate need for a Lead DBA:
 
Location: Boston MA 02110
Type: Direct Placement - FT Hours
Salary: DOE
 
Summary:  The Team Lead – Database Administration is responsible for organizing and participating in configuration, troubleshooting, and maintenance of the company's Production and Development environment databases.  The holder of this role will be primarily responsible for prioritization, ownership, tracking, and resolution of all database related incidents and requests to meet SLA requirements and development goals.  Their primary responsibilities will be to ensure a stable and performant SQL service in support of our Software as a Service platform.  Secondarily, they will serve as a subject matter expert in support of the development team, especially concerning (but not limited to) database structures, database performance, data security, and query optimization.  As the Team Lead, they will also be responsible for mentoring the team and ensuring that work is coordinated efficiently across multiple team members.
 
Essential Functions/ Responsibilities:
  • Database Design
    • Continuous improvement of database schema in conjunction with development
    • Recommendations and best practices for table structures, indexing, database sharding to ensure scalability of the platform as the business grows
  • SQL Server Maintenance
    • Backups, restores and defining recovery models
    • Responsible for database clustering
    • Proactively monitor SQL platform to ensure stability and uptime against SLA
    • Understand SQL Server use of underlying operating system platform and communicate requirements and standards to the system and network administrators
    • Evaluate, test and deploy new releases, patches and upgrades of the Microsoft SQL Server Platform
  • Reporting
    • Define and implement performance monitoring in a continuous improvement cycle
    • Define and implement capacity monitoring in a continuous improvement cycle
    • Produce regularly scheduled and ad hoc reports as needed
  • Performance Tuning
    • Performance tuning and Optimization (PTO), using native monitoring and troubleshooting tools
    • Index creation and management
  • SQL Automation
    • Work with Process Engineering and IT Operations team to tune automated SQL server deployment within pre-production environments
    • Implement operational automation using scripts and scheduling
    • Work with Process Engineering to automate frequently performed tasks in non-production environments for ad hoc development use (restores, etc…)
  • SQL Security
    • Table, field and database encryption per industry best practices
    • Server permissions model and monitoring of exceptions
  • Documentation creation and maintenance
    • Annotated schema layouts
    • Server configuration
    • Procedures
    • Design decisions and rationale
    • Other related documents as required
  • Production Support
    • On-Call rotation in support of Database Platform
    • Ad hoc management of data
    • Respond to alerts
    • Cross-train to support MySQL based platform
  • Team Leadership
    • Manage ticket workflow across all users
    • Build consensus on design decisions for presentation to Engineering and Operations management
    • Manage the on-call rotation effectively
    • Develop and maintain processes and standards of both design and administration
    • Work closely with the IT Operations team and the Application Management team to ensure that cross-team responsibilities and relationships are clear and stable

Competencies / Skills Requirements:
  • Excellent communication skills, both verbal and written
  • Technical troubleshooting and problem solving skills
  • Production stabilization orientation
  • Strong attention to detail

Supervisory Responsibility:
This position does not have direct supervisory responsibilities, but does serve as a coach, coordinator, and mentor for other positions in the department.
Required Education/Experience Requirements:
  • Diploma/University: Bachelor's degree in computer science or equivalent experience
  • Years of professional experience: 8-15 years of experience as a database administrator required; mobile and/or payment industry products/technology background a plus
  • Specific areas of experience or expertise:
    • Required: Expert knowledge of database systems with focus on Microsoft SQL Server and T-SQL
    • Preferred: Knowledge or experience in other modern programming languages or web development languages: Java, JavaScript, C/C++, HTML, HTML5, etc.
    • Required: Familiarity with common tools and techniques needed to develop, troubleshoot and maintain database systems
    • Preferred:  Involvement in the MSSQL Server Community, active PASS membership
    • Preferred:  Related Industry Certifications
    • Required:  Familiarity with current development support tools including: GIT, JIRA, Confluence, etc.
    • Preferred:  Working experience with MySQL
 
If qualified and interested, please send an updated copy of your resume to Allison at allison.weidinger@mondo.com
 
Thank you!