Job description
The position is described below. If you want to apply, click the Apply button at the top or bottom of this page. You'll be required to create an account or sign in to an existing one.
Need Help?
If you have a disability and need assistance with the application, you can request a reasonable accommodation. Send an email to Accessibility (accommodation requests only; other inquiries won't receive a response).
Regular or Temporary:
RegularLanguage Fluency: English (Required)
Work Shift:
1st shift (United States of America)Please review the following job description:
Candidate will help develop solutions and provide support on managed efforts, documenting requirements, and technical performance reviews. Also provide skills to build, document and support Microsoft SQL Server and related components.In addition, this position will:
- follow enterprise standards, procedures, physical data storage, maintenance, access, backup and recovery, documentation, security, and best practices in a team environment
- assist with analysis, performance, data movement, troubleshooting, and configuration recommendations
- provide insight and help implement database system maintenance, upgrades and serve as the escalation point for incident management, problem management and request fulfillment activities for the Operations division within IT Services.
***Telecommute/Remote options available***
ESSENTIAL DUTIES AND RESPONSIBILITIES
Following is a summary of the essential functions for this job. Other duties may be performed, both major and minor, which are not mentioned below. Specific activities may change from time to time.
1. Responsible for the installation, configuration and production turnover of Truist Database Services and servers.
2. Provides requirement analysis and evaluations for proposed data management software products and solutions. Develops or directs the development of utilities used for the monitoring, tuning and analysis of database systems.
3. Provide and assist with the creation of database(s), database schema and support for logical model with developments.
4. Maintain documentation, backup and recovery procedure for the physical and logical databases. Includes develop, monitor and maintaining backup and recovery solutions.
5. Assist with application developers, business users and project managers in the development of user access requirements, logical and physical database design, and disaster recovery as needed.
Assist with review of vendor configurations and patches adhering to best practices where allowed.
6. Provide technical writings and detailed documentation on technology standards and procedures.
7. Good understating of architecture principles within system and database technologies.
8. Ability to work with engineers groups on OS settings and recommendations.
9. Work with disk storage management group to determine appropriate disk platform and disk allocation configuration to support desired physical design and performance.
10. Independently be able to provide performance measures of transactional databases, identifying bottlenecks, disk analysis and other metrics to provide tuning recommendations.
11. Providing engineering support for industry best of breed applications for management of database systems and related security functions identifying risk.
12. Ability to make decisions for implementation, build and configuration for RDBMS and integration into the environment. Provide both solution blocks low -level designs for database systems
13. Support in developing and supporting automation solutions.
Skills and Competencies
Product Lifecycle Management
- Work closely with Production Engineering to maintain a product roadmap aligned with the business needs of Truist Data and Technology Services and appropriate team leads.
- Perform database reviews with Operations peer contacts for evergreen efforts and product changes or releases.
- Research and maintain a current understanding of available and evolving RDBMS and Database Service technology trends.
Project Execution and Service Design
- Perform project initiation activities including general requirements gathering and documentation, contributing in project status meetings and estimation activities with the Truist Estimation team.
- Identify and communicate project complications or roadblocks in a manner to reduce delays to original project timelines.
- Review basic High Level & Low Level designs documents using Microsoft Visio for each project and support the adherence to Database best practices.
- Develop strong relationships with internal Application, Operating systems, Data and Technology Services teams.
Tactical Operational Support & Technical Planning
- Familiarity with the engineering lifecycle for Databases including capacity planning, disaster recovery, backup & restore, and other related technical requirements in the below product areas.
- Proficient understanding and senior experience with the installation and configuration for the below database product areas.
- Product Areas:
- Operating Systems/Databases
- Microsoft Windows Server 2014, 2016, and 2019
- Microsoft SQL Server 2008, 2008R2, 2012, 2014, 2017 and 2019
- SSRS, SSIS, SSAS, familiarity with NLB’s for SSRS, and other technologies.
- Areas of proficiencies:
- Proficient skills with PowerShell and T-SQL
- Some familiarity with Ansible, GitLab, Visual Studio or Terraform is a plus
- Installation upgrade/patching
- Create, manage, and maintain database in IaaS and PaaS
- Solid SQL and procedural language skills with ability to tune plans
- Solid coding skills including PowerShell scripting and ability to automate database processes and task
- Intermediate administration and object creation and management
- Backup and Recovery
- Solid understanding of High Availability – Configure, install and support Always-On, mirroring, log shipping etc.
- Solid understanding of Disaster Recovery and Replication with implementation skills. Clustering and high availability understanding and implementation skills. This includes Always-On.
- Configuration and tuning capabilities that includes RDBMS, IO and metric gathering.
- Solid data movement experience.
- Analysis and Troubleshooting
- Monitoring, Trending and Tracking
- Scripting capabilities within the OS to assist with automation and gathering metrics for analysis.
- Azure principles and knowledge preferred
- Security and Risk Awareness. Capability to ready vendor security bulletins and correlate to enterprise environment.
- OS Knowledge and basic troubleshooting capabilities
- Operating Systems/Databases
- Collaborate and partner with peer teams to identify risk and security gaps and concerns and develop remediation plans.
- Provide excellent customer service, oral and written communication within a business and technical context.
- Team-oriented interpersonal skills. Ability to work independently or part of team.
- Ability to plan, organizes, troubleshoot and execute with strong problem solving skills.
Ability to cooperate with other related work teams across geographically dispersed locations
QUALIFICATIONS
Required Qualifications:
The requirements listed below are representative of the knowledge, skill and/or ability required. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
1. Bachelor's degree and five years of experience in development or application support or an equivalent combination of education and work experience.
2. In- depth knowledge in information systems and ability to identify, apply, and implement best practices.
3. Understanding of key business processes and competitive strategies related to the IT function.
4. Ability to plan and manage projects.
5. Ability to solve complex problems by applying best practices.
6. Ability to provide direction and mentor less experienced teammates.
7. Ability to interpret and convey complex, difficult, or sensitive information.
Preferred Qualifications:
1. Bachelor's degree and six years of experience or an equivalent combination of education and work experience.
2. Banking or financial services experience.
OTHER JOB REQUIREMENTS / WORKING CONDITIONS
Sitting
Frequently (25% - 50% of the time)
Lifting
Up to 25 lbs.
Visual / Audio / Speaking
Able to access and interpret client information received from the computer and able to hear and speak with individuals in person and on the phone.
Manual Dexterity / Keyboarding
Able to work standard office equipment, including PC keyboard and mouse, copy/fax machines, and printers.
Availability
Able to work all hours scheduled, including overtime as directed by manager/supervisor and required by business need.
Travel
Up to 25%
Truist supports a diverse workforce and is an Equal Opportunity Employer that does not discriminate against individuals on the basis of race, gender, color, religion, citizenship or national origin, age, sexual orientation, gender identity, disability, veteran status or other classification protected by law. Truist is a Drug Free Workplace.
EEO is the Law Pay Transparency Nondiscrimination Provision E-Verify
colinoncars.com is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, colinoncars.com provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, colinoncars.com is the ideal place to find your next job.