Sorry, this job is no longer accepting applications. See below for more jobs that match what you’re looking for!

Principal DBA Engineer

Expired Job

Invesco Houston , TX 77001

Posted 2 months ago

Invesco is a leading global asset management firm with more than $937Bin assets under management. We provide our retail and institutional clients a diverse and comprehensive range of investment capabilities to help people get more out of life. Invesco is publicly traded on the New York Stock Exchange (IVZ) and has about 7,000 employees in over 20 countries.

(*As of December 31, 2017)

Job Purpose (Job Summary): *

The Database Engineer will be a member of our senior technical support engineering team whose primary focus will be to assist in maintaining a secure, stable, and high performing compute environment. The core focus of this specific role will be on improving efficiency of operations, monitoring, tracing, and triaging of issues within our Microsoft SQL database infrastructure and applications.

This role requires advancedfunctional expertise in database engineering, troubleshooting, tuning, analysis, etc. This role may direct high level work on complex projects or initiatives. This role will serve as expert in the database area and will be sought out for input on significant technical and business decisions. This person may be responsible for the execution of complex initiatives and may contribute to strategic planning within their area of expertise. This person must havethe ability to apply standard troubleshooting techniques in support of rapid resolutions of issues, as well as an in-depth knowledge of IT operations, platforms, and disciplines. This role also includes advising teams on any recommended changes needed to the design of key applications, infrastructure systems and procedures.

This is a business-critical role that will involve tackling challenging, unique situations on a daily basis and will require interaction with multiple infrastructure and development teams in the company.


This position requires strong interpersonal and communication skills, an ability to work as part of a team or independently under minimal direction. Interfacing with teams outside of the IT Operations group to gather requirements, collaborate, evangelize and incorporate security policies will be a key component of this role.


This is a 24x7 on-call environment therefore this individual may be required to perform duties during off hours.

Key Responsibilities / Duties:

  • Be part of the team responsible for performance, monitoring, emergency response and capacity planning

  • Analyze large, complex systems to determine performance bottlenecks, application bugs, and opportunities to improve efficiency

  • Work closely with developers in troubleshooting wide array of issues, supporting new features and services, and insuring effective use of the computing infrastructure

  • Collaborate with teams to identify innovative ways to improve best practices and procedures

  • Mentor other team members on latest industry tools and techniques

  • Combine open-source and commercial technologies to build services that will positively impact the business

  • Serve as primary escalation point for critical database issues related to core systems and applications.

  • Create documentation of triage steps, procedures, policies and standards for various applications and systems

  • Participate in system architecture reviews of new or existing data applications, developing guidelines, and enterprise standards

  • Participate in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment

  • Collaborate with other engineering teams on new systems, technology, and support tools

Work Experience / Knowledge: *

  • 7 plus years of experience in IT

o 3-5 years experience in application support/tracing diagnosing systems hardware and software

  • Experience working in a fast-paced, rapidly evolving environment while interfacing with multiple internal clients.

  • Supporting Microsoft SQL Databases in medium to large datacenter.

o In-depth experience and knowledge supporting Microsoft SQL 2008, 2012, 2014

o -Tracing/Troubleshooting

o Comprehensive knowledge of SQL tuning, security, extended event tracing and diagnostic tools.

  • Experience in CE troubleshooting, statistics, and execution plan tracing and troubleshooting

o -Performance Tuning

  • Capture and analyze database activity to identify improvements in indexing, file structure, maintenance processes, and query performance

  • Plan and conduct database architecture assessments that examine DBMS and database configuration and performance

o _-Replication Technology _

  • Familiarity with backups, restores and recovery models.

  • Experience utilizing high availability (HA) and disaster recovery (DR) options for MSSQL Server.

log shipping, transactional replication as well as high availability groups


Experience using Actifio backup and replication software a plus.

  • Additional skillsets desired

o Working knowledge of Storage Protocols and systems, iSCSI, NAS, Fiber Channel, and NETAPP appliances

o Experience analyzing windows perfmon, and etl storage tracing along with basics of storage networks.

o Experience with monitoring tools such as, SolarWinds DPA, SentryOne Plan Explorer, or equivalent.

o Experiencesupporting or using Wiki based documentation systems

  • Experience with PowerShell, SQL batch coding, Business Objects, and Informatica workflows

o Version control experience using systems such as GIT, Mercurial, and MS Team Foundation a plus

Skills / Other Personal Attributes Required:

  • Good communication, written and interpersonal skills, presenting ideas in user-friendly language

  • Ability to contribute in a team environment is critical

  • Ability to absorb and retain information quickly, and conduct complex analysis and present data in a meaningful way

  • Must have the ability to handle multiple tasks, prioritize work, meet deadlines and concentrate on details

  • Strong analytical skills and detail orientation

  • Open minded, flexible, and able to work in a fast-paced dynamic environment

  • A fan of automation with the ability to bring additional knowledge around this topic

  • Someone who is highly self-motivated and directed


Formal Education:(minimum requirement to perform job duties)

Degree in Information Technology, Computer Science, related technical field or equivalent work experience.

Working Conditions:

  • Normal work environment with little exposure to excessive noise, dust and temperature

  • Intense visual concentration may be required along with the ability to lift and move objects weighing up to 20 pounds

  • Frequent sitting and intermittent walking is also required

  • Normally works a regular schedule of hours

  • Regular 24/7 on-call rotation for Crisis Management required. Not generally on-call for IT BR Implementation unless a disaster is declared (or one is imminent).

  • Required to work weeknights/weekends during Disaster Recovery testing or if a disaster or crisis situation has been declared

  • Domestic and international travel is possible

The above information on this description has been designed to indicate the general nature and level of work performed by employees within this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job. The job holder may be required to perform other duties as deemed appropriate by their manager from time to time.

Invesco is committed to fair and accessible employment practices. If selected for an interview, we will work with you to ensure that your interview is accessible and accommodation is provided. Please contact us at or to let us know if you require accommodation for an interview due to a disability.

Title:Principal DBA Engineer

Location:Texas-Houston-11 Greenway Plaza

Requisition ID:22299


See if you are a match!

See how well your resume matches up to this job - upload your resume now.

Find your dream job anywhere
with the LiveCareer app.
Download the
LiveCareer app and find
your dream job anywhere
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Principal DBA Engineer

Invesco

Posted 3 months ago

VIEW JOBS 9/14/2018 12:00:00 AM 2018-12-13T00:00 Invesco is a leading global asset management firm with more than $937B* in assets under management. We provide our retail and institutional clients a diverse and comprehensive range of investment capabilities to help people get more out of life. Invesco is publicly traded on the New York Stock Exchange (IVZ) and has about 7,000 employees in over 20 countries. (*As of December 31, 2017) Job Purpose (Job Summary): The Database Engineer will be a member of our senior technical support engineering team whose primary focus will be to assist in maintaining a secure, stable, and high performing compute environment. The core focus of this specific role will be on improving efficiency of operations, monitoring, tracing, and triaging of issues within our Microsoft SQL database infrastructure and applications. This role requires advanced functional expertise in database engineering, troubleshooting, tuning, analysis, etc. This role may direct high level work on complex projects or initiatives. This role will serve as expert in the database area and will be sought out for input on significant technical and business decisions. This person may be responsible for the execution of complex initiatives and may contribute to strategic planning within their area of expertise. This person must have the ability to apply standard troubleshooting techniques in support of rapid resolutions of issues, as well as an in-depth knowledge of IT operations, platforms, and disciplines. This role also includes advising teams on any recommended changes needed to the design of key applications, infrastructure systems and procedures. This is a business-critical role that will involve tackling challenging, unique situations on a daily basis and will require interaction with multiple infrastructure and development teams in the company. This position requires strong interpersonal and communication skills, an ability to work as part of a team or independently under minimal direction. Interfacing with teams outside of the IT Operations group to gather requirements, collaborate, evangelize and incorporate security policies will be a key component of this role. This is a 24x7 on-call environment therefore this individual may be required to perform duties during off hours. Key Responsibilities / Duties: * Be part of the team responsible for performance, monitoring, emergency response and capacity planning * Analyze large, complex systems to determine performance bottlenecks, application bugs, and opportunities to improve efficiency * Work closely with developers in troubleshooting wide array of issues, supporting new features and services, and insuring effective use of the computing infrastructure * Collaborate with teams to identify innovative ways to improve best practices and procedures * Mentor other team members on latest industry tools and techniques * Combine open-source and commercial technologies to build services that will positively impact the business * Serve as primary escalation point for critical database issues related to core systems and applications. * Create documentation of triage steps, procedures, policies and standards for various applications and systems * Participate in system architecture reviews of new or existing data applications, developing guidelines, and enterprise standards * Participate in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment * Collaborate with other engineering teams on new systems, technology, and support tools Work Experience / Knowledge: * 7 plus years of experience in IT * 3-5 years' experience in application support/tracing diagnosing systems hardware and software * Experience working in a fast-paced, rapidly evolving environment while interfacing with multiple internal clients. * Supporting Microsoft SQL Databases in medium to large datacenter. * In-depth experience and knowledge supporting Microsoft SQL 2008, 2012, 2014 * -Tracing/Troubleshooting * Comprehensive knowledge of SQL tuning, security, extended event tracing and diagnostic tools. * Experience in CE troubleshooting, statistics, and execution plan tracing and troubleshooting * -Performance Tuning * Capture and analyze database activity to identify improvements in indexing, file structure, maintenance processes, and query performance * Plan and conduct database architecture assessments that examine DBMS and database configuration and performance * -Replication Technology * Familiarity with backups, restores and recovery models. * Experience utilizing high availability (HA) and disaster recovery (DR) options for MSSQL Server. * log shipping, transactional replication as well as high availability groups * Experience using Actifio backup and replication software a plus. * Additional skillsets desired * Working knowledge of Storage Protocols and systems, iSCSI, NAS, Fiber Channel, and NETAPP appliances * Experience analyzing windows perfmon, and etl storage tracing along with basics of storage networks. * Experience with monitoring tools such as, SolarWinds DPA, SentryOne Plan Explorer, or equivalent. * Experience supporting or using Wiki based documentation systems * Experience with PowerShell, SQL batch coding, Business Objects, and Informatica workflows * Version control experience using systems such as GIT, Mercurial, and MS Team Foundation a plus Skills / Other Personal Attributes Required: * Good communication, written and interpersonal skills, presenting ideas in user-friendly language * Ability to contribute in a team environment is critical * Ability to absorb and retain information quickly, and conduct complex analysis and present data in a meaningful way * Must have the ability to handle multiple tasks, prioritize work, meet deadlines and concentrate on details * Strong analytical skills and detail orientation * Open minded, flexible, and able to work in a fast-paced dynamic environment * A fan of automation with the ability to bring additional knowledge around this topic * Someone who is highly self-motivated and directed Formal Education: (minimum requirement to perform job duties) Degree in Information Technology, Computer Science, related technical field or equivalent work experience. Working Conditions: * Normal work environment with little exposure to excessive noise, dust and temperature * Intense visual concentration may be required along with the ability to lift and move objects weighing up to 20 pounds * Frequent sitting and intermittent walking is also required * Normally works a regular schedule of hours * Regular 24/7 on-call rotation for Crisis Management required. Not generally on-call for IT BR Implementation unless a disaster is declared (or one is imminent). * Required to work weeknights/weekends during Disaster Recovery testing or if a disaster or crisis situation has been declared * Domestic and international travel is possible The above information on this description has been designed to indicate the general nature and level of work performed by employees within this role. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities and qualifications required of employees assigned to this job. The job holder may be required to perform other duties as deemed appropriate by their manager from time to time. Invesco is committed to fair and accessible employment practices. If selected for an interview, we will work with you to ensure that your interview is accessible and accommodation is provided. Please contact us at accessibility@invesco.ca or 1.800.874.6275 to let us know if you require accommodation for an interview due to a disability. Invesco Houston TX

Principal DBA Engineer

Expired Job

Invesco