Apply Now    

Microsoft SQL Server Database Administrator

Req #: 180036326
Location: Houston, TX, US
Job Category: Technology
Job Description:

As a Database Administrator, you will administer, maintain and utilize policies and procedures for ensuring the security and integrity of the databases. Implement data models and database designs, data access and table maintenance codes; resolve database performance issues, database capacity issues, replication, and other distributed data issues. Support production DBA in daily or emergency procedures to resolve issues. Lead the efforts of installing and maintaining database management software.

You will work with the Information Architect and Database Designer to help implement the physical data model. Help develop and validate the database implementation plan. Create database objects and maintain their physical organization/relationships. Support the data loads into the databases. Ensure that the application, and any enhancements, interact efficiently with the database. Develop and implement database performance monitoring process and analyze monitoring data for performance optimization opportunities. Create/Implement database maintenance plan to ensure data integrity. Manage the on-site backup and recovery process and/or support the off-site backup and recovery teamsĀ· Plan for and execute any required database upgrades and migration (patches etc.)

  • Required Skills:
    Database Platforms Microsoft SQL Server
    Operating Systems needed: Windows
     
    • 6+ years experience as a DBA supporting Microsoft SQL Server 2005/2008/2012. Experience in SSIS, SSAS & OLAP preferred
    • Solid experience to setup and support SQL Server Mirroring, Log Shipping, Mirroring/log forwarding, Clustering and other methods of disaster recovery
    • Backups/restores, DBCC, reorgs & update statistics
    • Solid experience in database migration from one platform to another, patching, upgrade, data loading, security, capacity planning, performance monitoring and tuning
    • Ability to analyze traces, debug stored procedures, triggers and package
    • Experience in database design and some logical modeling knowledge
    • Solid understanding of Windows operating system, LDAP and Active Directory
    • Clear understanding of Database Architecture, Operating Systems, Client/Server Architecture, Middleware and Hardware (Servers, SAN, Network)
    • Demonstrate good written and verbal communication skills in English language
    • Ability to collaborate effectively with other operational support teams and vendors to support the service. Team focus and customer oriented
    • Excellent time management and organizational skills
    • Demonstrate ownership and good skills on problem management, problem solving and prevention of SLA breach under Incident / Problem Management processes
     
     
    Nice to have:
    • Database auditing
    • Financial industry experience
    • Python programming/automation
     

JPMorgan Chase is an Equal Opportunity and Affirmative Action Employer, M/F/D/V.
Apply Now    
Link for schema

Join our Talent Community

Not ready to apply? Leave your information with us and we will keep you up to date with new career opportunities.

Other Information

Apply Using LinkedIn

You can also apply using your LinkedIn® profile. It may save you some time because your information will be automatically transferred into our system. Just click on the LinkedIn logo when you get to the application screen and follow the directions.

Submit an Updated Résumé

During the application process, be sure you have an up-to-date copy of your Résumé, your cover letter and any other documentation you would like to submit.