15 days old

Database Administrator II

TransCore, LP
Long Island City, NY 11101
  • Job Code
    DATAS09185

TransCore (TRN), a subsidiary of Roper Technologies, Inc. (NYSE: ROP) is seeking a full-time Database Administrator II to join our team. This position will be located in our NY or Houston, TX offices.


Job Summary:The Database Administrator is responsible for maintaining, managing, and optimizing MS-SQL Server databases in support of Enterprise and External Web applications. This includes working closely with system managers and developers to optimize systems for availability and performance; and provide data analysis services. The Database Administrator also is responsible for maintaining applications, processes, and maintenance procedures; performance tuning; and documentation and management of changes to database operations


Essential Duties and Responsibilitiesinclude the following. Other duties may be assigned.


  • Propose innovative solutions and communicate ideas to the supervisor and to the group.

  • Work with software developer(s) and senior team members to develop database designs and enhancements.

  • Provide technical assistance by responding to inquiries regarding errors, problems, or questions.

  • Analyze, install and test upgrades of products.

  • Monitor performance of applications and/or programs after implementation, taking actions as required.

Education: Bachelor's degree (B.A.) in computer science or equivalent from four-year college or university


Required Skills & Experience:


  • 6+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2019,2016,2012, SQL Server 2008 R2 and 2008.

  • Working experience in Always-On Availability Groups (AAG) and HA/DR Troubleshooting

  • Expertise in T-SQL writing stored procedures, triggers and functions.

  • Administering SQL Server High Availability and Disaster Recovery strategies.

  • Implemented the new SQL Server 2019/2016 mechanisms like data compression, online indexing, Contained Databases, security principals and AAG.

  • Worked on logical and physical data base modeling with UML and ERWIN tools.

  • Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.

  • Having hands on experience in DR processes including Log shipping and Database Mirroring and AOAG

  • Troubleshoot performance problems, fine-tuning of databases and index Analysis.

  • Worked on SQL Server 2012/2016 migration from SQL Server 2008 / 2005.

  • Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.

  • Working knowledge in Analysis Services (SSAS), Reporting Services (SSRS) and Clustering.

  • 24 X 7 Production Database on Call Support


    Software





    Posted: 2021-01-05 Expires: 2021-02-03
    Sponsored by:
    ADP Logo
    Sponsored by:
    Bank of America Logo

    Featured Jobs[ View All ]

    Featured Employers

    Before you go...

    Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

    Share this job:

    Database Administrator II

    TransCore, LP
    Long Island City, NY 11101

    Join us to start saving your Favorite Jobs!

    Sign In Create Account
    Powered ByCareerCast