Sr. Architect

Job Description:

Sr. Architects for various and unanticipated worksites throughout the U.S. (HQ: Chicago, IL). Architect, define, evaluate, design, create, administer, implement and test large enterprise databases and database structures including transaction loads and connections, convert standalone databases to clustered databases. Ensure data replication, data recovery, maintenance, data integrity, and space requirements for databases are met through formulations and monitoring of policies, procedures, and standards relating to database management. Apply service packs and cumulative updates and tune poorly performing databases to ensure optimal configuration. Monitor database performance. Maintain database backup/recovery and restore environments, review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirement considerations. Triage and troubleshoot issues for Relational Database Models (RDMS) (logical and physical) and platform environments and facilitate application development and problem resolution. Monitor file system space and database allocation and verify efficient use of disk storage to optimize impact and provide application development staff an optimal development environment and current data. Perform clustering and trend/growth analyses. Automate procedures and reorganize or defragment databases, tables, and indexes in order to provide efficient database environments, maximize productivity, and improve performance. Upgrade databases in a side-by-side and/or in-place configurations. Work with customers and communicate complex technical information in articulate manner. Mentor junior database administrators. Technical Environment: MS SQL server platforms, SQL (programming & optimizing code); Management Data Warehouse, SQL Performance Dashboard, Database Engine Tuning Advisor, SQL Dynamic Functions and Views, and Windows Performance Monitor and Resource Monitor. writing T-SQL & stored procedures & query tuning online transaction systems; database modeling techniques and development methodology; data security techniques/measures (user & role permissions, auditing, penetration & vulnerability tests, restricting SQL access); schema design of table spaces, rollback segments, data files.

Job Requirement:

*Master’s degree in Computer Science or Computer Engineering or any Engineering field plus 3 years of experience as a Database Administrator or in database administration and support required. Required Skills: Must have experience with relational database models, logical and physical database design and architecture; hands-on database modeling techniques and development methodology; physical schema design of table spaces, rollback segments, data files; design and implement backup and recovery of RDBMS under failover and switchover events; Oracle, MySQL, Postgres; SQL (programming & optimizing code); writing T-SQL and stored procedures & query tune online transaction systems; performing installations, tuning & optimization, monitoring, backup/restore, troubleshooting, data replication, D/R & business continuity, clustering & trend/growth analysis; data security measures (user & role permissions, auditing, penetration & vulnerability tests, restricting SQL access); demonstrated experience evaluating large database transaction loads & connections (over 15,000 application transactions/second); experience working with customers in high-pressure situations & complex environments; excellent verbal & written communication skills. Telecommuting permitted. (*Bachelor’s degree in Computer Science or Computer Engineering or any Engineering field plus 5 years of progressive experience as a Database Administrator or in database administration and support also acceptable).

Benefits & Pay Scale Information:

TransUnion provides flexible benefits including flexible time off for exempt associates, paid time off for non-exempt associates, up to 12 paid holidays per year, health benefits (including medical, dental, and vision plan options and health spending accounts), mental health support, disability benefits, up to 12 weeks of paid parental leave, adoption assistance, fertility planning coverage, legal benefits, long-term care insurance, commuter benefits, tuition reimbursement, charity gift matching, employee stock purchase plan, 401(k) retirement savings with employer match, and access to TransUnion’s Employee Resource Groups. Spousal, domestic partner, and other eligible dependent coverage is available on select health and welfare plans.

The U.S. base salary range for this position is $133,973/yr - $136,871/yr. annually. Regular, fulltime non-sales positions may be eligible to participate in TransUnion’s annual bonus plan. Certain positions may also be eligible for long-term incentives and other payments based on applicable company guidance and plan documents.

We are committed to being a place where diversity is not only present, it is embraced. As an equal opportunity employer, all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, disability status, veteran status, genetic information, marital status, citizenship status, sexual orientation, gender identity or any other characteristic protected by law.

#LI-DNI

Qualified applicants with arrest or conviction records will be considered for employment in accordance with applicable law, including the Los Angeles County Fair Chance Ordinance for Employers, the San Francisco Fair Chance Ordinance, Fair Chance Initiative for Hiring Ordinance, and the California Fair Chance Act.

Adherence to Company policies, sound judgment and trustworthiness, working safely, communicating respectfully, and safeguarding business operations, confidential and proprietary information, and the Company’s reputation are also essential expectations of this position.

Beware of scams tied to potential career opportunities. If you received a link, email, text or social media communication you weren’t expecting from TransUnion, take a moment to confirm the relevant information. Be wary when providing personal information. Contact careers@transunion.com or (312) 258-1717 for assistance.