Senior SQL Server Database Administrator

**Career Area**:Information Technology
**IT'S YOUR TIME

It's Your Career. Make it Matter

Caterpillar is the world’s leading manufacturer of construction and mining equipment, diesel and natural gas engines, industrial gas turbines and diesel-electric locomotives. The company principally operates through its three primary segments - Construction Industries, Resource Industries and Energy & Transportation - and also provides financing and related services through its Financial Products segment.

At Caterpillar, you build what matters—whether it’s the career you want, crucial work skills, strong relationships or new digital technologies. There are big jobs to be done worldwide—building critical infrastructure, bolstering local economies, meeting the demand for energy—and that work is powered by our people, which is build through diversity, aiming to achieve the best results.

If you are looking for personal and professional growth in a company with an inclusive culture that seeks equity, respect differences and believes in employee's potential, this is the right place We consider in all positions people with disabilities, diverse gender, culture, ethnicity, religion, age, generation, race, nationality and sexual orientation.

**JOB DUTIES**:
This role understands and executes standard work to ensure the scope of services achieve and maintain appropriate level of risk and compliance to internal policies and procedures, including those relating to sustainability, cybersecurity, SOX, and IT General Controls.

**Other job duties include, but not limited to**:

- Competent to perform all programming, project management, and development/deployment assignments without close supervision; normally assigned the more complex aspects of systems work.
- Acts as team leader for development and support groups; provides programming and Infrastructure technology leadership, guidance, and assistance to other team members.
- Works directly on complex technical problem identification and resolution, including responding to off-shift and weekend support calls.
- Deploys or integrates infrastructure technology components based on requirements gathered from customers.
- Performs integrated testing and customer acceptance testing of components that requires careful planning and execution to ensure timely, quality results.
- Fully knowledgeable of the relevant programming languages, program design and specification development, programming logic, logic diagrams, system analysis techniques, testing, debugging, documentation standards, file design, storage and internal systems and cross platform infrastructure components; can provide training on these topics for others;
- Performs implementation and integration tasks for medium to large, complex in-house developed systems and/or purchased software solutions.
- Assists customers with documentation, training, and usability efforts.
- Integrates processes across functional organizations.
- Typically serves as a team member on one or more 6 Sigma projects.
- Employee may also be responsible for performing other job duties occasionally as assigned.

**BACKGROUND/EXPERIENCE**:

- Requires a relevant degree, technical certification, or equivalent experience.
- The incumbent should be knowledgeable of the relevant programming languages; computing hardware and software; infrastructure elements, and current development processes and tools.
- Six to ten years in development and support work related to systems or infrastructure technology is common.
- In addition, the incumbent should have a good knowledge of Caterpillar policies and procedures, and a general understanding of Caterpillar’s organization."
- Manage the Corporate SQL Server DBA team in US, and India Team ; Assign tasks to individual DBAs and Monitor them
- Ensure the Service Level Agreements (SLA) are met for the tickets assigned to incident queues
- Conduct weekly team meetings with the team (one for US and one for non US may be needed due to time zone differences)
- Schedule weekly meeting with the supervisor to go over the status of projects, queues, issues, and escalations needed where applicable
- Maintain and administer 570+ instances supported by GIS in NA, EAME, and AP including Solar and Perkins including configuration and tuning, and Account Management
- Install and Configure SQL Server 2012 Developer, Enterprise, Standard, and Express Editions onwards
- Perform Application DBA work when needed
- Diagnose, troubleshoot, and resolve SQL Server issues when necessary, during on/off-shift and weekends.
- Provide technical leadership for all aspects of database management such as database lifecycle management, monitoring, support, disaster recovery, compliance, and standards.
- Research new SQL database versions, features, tools, and technologies with an Enterprise perspective to meet customer needs while maintaining a secure database environment.
- Research, benchmark, and suggest improvements to database support