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

Lead DBA in Pasadena, CA at DISYS

Date Posted: 12/3/2018

Job Snapshot

Job Description

Job Description / Qualifications Required

Senior/Lead Database Administrator

Reporting to the Manager of Database Administration, the Lead/Sr. DBA will contribute to the overall engineering, design, build and high level support of all existing and new Microsoft SQL Server systems (SQL 2000/2005/2008/2012/2016). As a lead within the Technology Operations Production DBA team, the successful candidate will need to work closely with our internal clients and team members to develop consensus and find solutions to problems facing their business constituents.

The Lead/Sr. Database Administrator will work with all of the IT development teams to assist in the implementation, management, development and monitoring of the databases that supports the company's IT data integrations initiatives. This candidate should be able to lead projects from inception to completion with little or no support.

Duties and Responsibilities

  • Work to ensure that the proper hardware resources are allocated to the databases, and to ensure high resilience and performance tuning.
  • To proactively monitor the database systems to ensure secure services with minimum downtime.
  • Responsible for providing trend analysis to management team to enable them to make informed decisions regarding resource management.
  • Responsible for troubleshooting and problem solving SQL development issues.
  • Responsible for assisting developers to optimize, tune and enhance database queries
  • Responsible for improvement and maintenance of all databases, to include rollout and upgrades.
  • Responsible for implementation and release of database changes according to agreed timescales and costs.
  • Responsible for proposing and implementing database architectural changes to make database infrastructure highly scalable and optimized
  • Green Dot operates a 24x7 card processing environment. On-call / off-hours deployments and support will be required.
  • To take on technical leadership responsibilities of database projects across various teams in the organization 
  • Responsible for mentoring developers on data modeling best practices and enabling them to come up with a optimized data model 

Skills / Attributes Required

  • Good to have Masters in Computer Science or related field
  • 8+ years of in-depth SQL Server Database Administration experience
  • Extensive experience of managing multiple MS SQL 2008/2012/2014/2016 servers on enterprise-class servers clusters running Windows 2003/2008/2012
  • Strong self-sufficiency and initiative working on Database projects
  • Experience in leading and mentoring team members 
  • Practical experience in monitoring and tuning a database to provide a high availability service.
  • Experience with T-SQL, OLAP, DTS, SSIS and stored procedures.
  • Practical experience in managing internal and external Microsoft SQL Server database security
  • Strong knowledge of Multi-Instance implementations and methodologies.
  • Experience with Replication, Log Shipping, Change Data Capture and Database Mirroring
  • Knowledge of SQL Service Broker
  • Understanding of High Availability, Business Continuity, and Disaster Recovery concepts as they relate to Open Systems architecture
  • Experience on working with SQL Server in Amazon cloud or/and Azure platform is definitely a plus
  • Experience of working with mysql database
  • Knowledge of NoSQL databases is a good to have skill

Job Requirements

Digital Intelligence Systems, LLC. is an Equal Opportunity Employer, M/F/D/V. We do not discriminate against any employee or applicant because they inquired about, discussed, or disclosed compensation. Email recruitinghelp @ disys.com to contact us if you are an individual with a disability and require accommodation in the application process.Digital Intelligence Systems, LLC. is an Equal Opportunity Employer, M/F/D/V. We do not discriminate against any employee or applicant because they inquired about, discussed, or disclosed compensation. Email recruitinghelp @ disys.com to contact us if you are an individual with a disability and require accommodation in the application process.