Job Description
Arcadia, CA
Senior/Lead Database Administrator
Client’s Technology Operations department is responsible for developing and enhancing infrastructure and applications to support the growth of the business and to promote a highly available and stable computing environment.
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
Responsible for ensuring availability and performance of all company databases.
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
Client operates a 24x7 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 an optimized data model
Skills / Attributes Required
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 and knowledge of NoSQL databases
Job Type: Full-time
Salary: $120,000.00 to $140,000.00 /year
Experience:
T-SQL: 8 years (Preferred)
MySQL: 8 years (Preferred)
Database Administration: 8 years (Preferred)
managing multiple MS SQL 2008/2012/2014/2016 servers: 8 years (Preferred)
T-SQL, OLAP, DTS, SSIS and stored procedures: 8 years (Preferred)
Education:
Master's (Preferred)
Senior/Lead Database Administrator
Client’s Technology Operations department is responsible for developing and enhancing infrastructure and applications to support the growth of the business and to promote a highly available and stable computing environment.
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
Responsible for ensuring availability and performance of all company databases.
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
Client operates a 24x7 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 an optimized data model
Skills / Attributes Required
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 and knowledge of NoSQL databases
Job Type: Full-time
Salary: $120,000.00 to $140,000.00 /year
Experience:
T-SQL: 8 years (Preferred)
MySQL: 8 years (Preferred)
Database Administration: 8 years (Preferred)
managing multiple MS SQL 2008/2012/2014/2016 servers: 8 years (Preferred)
T-SQL, OLAP, DTS, SSIS and stored procedures: 8 years (Preferred)
Education:
Master's (Preferred)
💡 Quick Summary
Seeking a career-building opportunity? The Sr. Database Administrator position is now open for candidates interested in the Database Administrator sector. This role in Arcadia offers a professional environment and growth potential.
Requirement Snapshot: Candidates should possess basic communication skills, a proactive attitude, and the ability to work in a team. Experience in Database Administrator is a plus.
