Database Administrator II

TransCore (TRN), a subsidiary of ST Engineering, is seeking an experienced and talented Database Administrator II to join our Raleigh, North Carolina Team.

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.

Qualifications: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. The essential job duties and responsibilities listed below are representative of the knowledge, skill, and / or ability required. Reasonable accommodation may be made to enable individuals with disabilities to perform these activities.

Mandatory Requirement: This is an onsite (non-remote) office position for the TransCore NC Raleigh Office.

Essential Duties and Responsibilities include 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.
• Proactive monitoring for logical (indexes, bad joins, best practices) and physical (file-group layout, disk latency) problems.
• Capacity planning - monitoring growth, pro-active archiving.
• Monitor database performance, uptime, implement changes and apply new patches and versions when required.
• Monitor performance of applications and/or programs after implementation, taking actions as required.
• Assist with the creation and maintenance of the organization data warehouse.
• Troubleshoot application sluggishness and poor performance.
• Optimize SSRS reports and queries for performance, scalability, and efficiency, ensuring timely delivery and responsiveness of reports.

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

Required Skills & Experience:

• 6-8 years of experience in Database Administration for very large and complex databases in SQL Server 2022,2019,2016, 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, Cursor 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.
• 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.
• Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
• Troubleshoot performance problems, fine-tuning of databases and index Analysis.
• Strong knowledge and experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
• Generates regular reports (as needed), configurations and standard operating procedures. Develops automated and ad hoc reports for business requirements.
• Monitor database performance, implement changes and apply new patches and versions when required.
• Performing debugging procedures on database scripts and programs, as well as resolving conflicts.
• Worked on SQL Server 2019/2022 migration from SQL Server 2016.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Ensure all proposed resolutions are tested and cross-checked before deployment.
• Working knowledge in Analysis Services (SSAS), and Clustering.
• Proficient with MS SSRS (Required).
• Familiarity with XML in SQL.
• Familiarity with Redgate monitoring tools.
• Strong commitment to effective communication laterally to support teams and vertically to senior management.
• 24 X 7 Production Database on Call Support.

Additional Preferred Experience:

• Experience with Amazon Web Services (AWS) and Microsoft Azure.
• Experience with data visualization tools (e.g. Power BI, Tableau).

Applicants must be authorized to work permanently for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment visa.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities

The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)