TransUnion's Job Applicant Privacy Notice
What We'll Bring:
Job Summary
Team is responsible for the feature development for Rental Screening web-based applications. The product is on Microsoft technology stack with .NET Core, C#, Angular, Web API, and SQL Server / Aurora PostgreSQL. Product web based with web/micro service-based backend engine.
We're looking for a DBA with significant background in database development. Your success in this position will depend on your outstanding communication skills as well as your ability to work in an environment characterized by rapid change, the need for cross department collaboration, and with evolving goals. Extensive experience in database administrative and development processes, practices, tools, and environments is a must, as is an intimate knowledge of software development lifecycle processes.
What You'll Bring:
Job Description
Requirements:
• Degree in computer science or equivalent
• 10+ years of MS SQL Server Database Administration and Development
• 3+ years of PostgreSQL Database Administration and Development
• Experience with database upgrades and migrations
• Experience with database performance tuning and optimizing stored procedures
• Experience with designing, creating and monitoring database environments
• Experience with TSQL, Stored Procedures, Triggers, and Views
• Experience with SSIS, SSRS, and ETL development
• Experience with Agile/Scrum methodologies
We’d Love to See:
• Experience with database migration from on premise to AWS cloud
• Experience with Amazon Aurora PostgreSQL
• Experience with PL/pgSQL
• Experience with DevOps technologies in a cloud environment (AWS preferred)
Additional Job Description
Developer Responsibilities
• Database Coding: With limited direction, develop code, test, debug, maintain, modify, and install moderately complex software programs. Applies structured programming techniques and adhere to coding standards. Use knowledge of available utilities to simplify tasks. Apply structured programming techniques and adheres to coding standards, although some deviation from the standards may be expected for development efforts. Participates in code walkthroughs.
• Analysis/Design: Analyze moderately complex technical requirements and make determinations for modifications of existing computer programs/modules or if new programs/modules need to be developed for a specific application, system, and/or database. Independently analyze and document test results to ensure that programs are meeting the technical requirements. Partner with designers to update technical requirements documentation and make recommendations for re-design and/or re-coding of programs that do meet desired specifications.
• Documentation: Develop program specifications and flowcharts, (data flows, job flows, etc.), for stand-alone programs or systems. Prepare concise internal program documentation on program development and revisions. Prepare on-line help, FAQs, user guides and operational instruction manuals.
• Communication: Conveys problems, solutions, updates and project status to peers, customers, and management. Develops and maintains program, systems, and user documentation.
• Planning: Prepare time estimates for assigned tasks. Attends post-implementation reviews.
Impact You'll Make:
.
TransUnion Job Title
Sr Consultant, Database Administration and Storage