Database Administrator/Research Analyst, Wharton Real Estate Center

University Of Pennsylvania Philadelphia , PA 19107

Posted 2 months ago

University Overview

The University of Pennsylvania, the largest private employer in Philadelphia, is a world-renowned leader in education, research, and innovation. This historic, Ivy League school consistently ranks among the top 10 universities in the annual U.S.

News & World Report survey. Penn has 12 highly-regarded schools that provide opportunities for undergraduate, graduate and continuing education, all influenced by Penn's distinctive interdisciplinary approach to scholarship and learning. As an employer Penn has been ranked nationally on many occasions with the most recent award from Forbes who named Penn one of America's Best Employers By State in 2021.

Penn offers a unique working environment within the city of Philadelphia. The University is situated on a beautiful urban campus, with easy access to a range of educational, cultural, and recreational activities. With its historical significance and landmarks, lively cultural offerings, and wide variety of atmospheres, Philadelphia is the perfect place to call home for work and play.

The University offers a competitive benefits package that includes excellent healthcare and tuition benefits for employees and their families, generous retirement benefits, a wide variety of professional development opportunities, supportive work and family benefits, a wealth of health and wellness programs and resources, and much more.

COVID-19 vaccination is a requirement for all positions at the University of Pennsylvania. New hires are expected to be fully vaccinated before beginning work at the University. For more information about Penn's vaccine requirements, visit the Penn COVID-19 Response website for the latest information.

Posted Job Title

Database Administrator/Research Analyst, Wharton Real Estate Center

Job Profile Title

Database Administrator

Job Description Summary

The successful candidate will support faculty research in a number of areas within the Real Estate Center, including real estate, public policy, and urban economics. Computer programming skills are necessary; ability to analyze data and write reports required.

We anticipate that the successful candidate would work at the Center for up to two-three years, before going on to graduate programs or careers in real estate, finance, economics, or related disciplines. Independent thinking, a thorough understanding of economics, and self-motivation are highly valued in performing these functions. Candidate is expected to begin work in the summer of 2023.

Job Description

Job responsibilities include collecting, designing, implementing and maintaining moderately complex databases; using access methods, access time, device allocation, validation checks, reorganization and statistical methods. Perform a variety statistical and econometric analyses.

Write research reports, and provide research-related programming support. Independent thinking, a thorough understanding of economics, and self-motivation are highly valued in performing these functions. Ability to analyze data requirements, maintain database dictionaries, and integration of systems through database design is essential.

Must work proficiently in most phases of database management. Position is contingent upon continued funding.

Qualifications

BA/BS in Economics, Statistics, Finance, Mathematics, Computer Science or another closely related discipline and 1-2 years of experience is required or equivalent combination of education and experience.

Working Conditions

Office, library, computer room

Physical Effort

Typically sitting at a desk or table; Occasional lifting 50 lb. or less

Job Location - City, State

Philadelphia, Pennsylvania

Department / School

Wharton School

Pay Range

$43,919.00 - $90,263.00

Salary offers are made based on the candidate's qualifications, experience, skills, and education as they directly relate to the requirements of the position, as well as internal and market factors and grade profile.

Affirmative Action Statement

Penn adheres to a policy that prohibits discrimination on the basis of race, color, sex, sexual orientation, gender identity, religion, creed, national or ethnic origin, citizenship status, age, disability, veteran status, or any other legally protected class.

Special Requirements

Background check required after a conditional job offer is made. Consideration of the background check will be tailored to the requirements of the job.

University Benefits

  • Health, Life, and Flexible Spending Accounts: Penn offers comprehensive medical, prescription, behavioral health, dental, vision, and life insurance benefits to protect you and your family's health and welfare. You can also use flexible spending accounts to pay for eligible health care and dependent care expenses with pre-tax dollars.

  • Tuition: Take advantage of Penn's exceptional tuition benefits.

    You, your spouse, and your dependent children can get tuition assistance here at Penn. Your dependent children are also eligible for tuition assistance at other institutions.

  • Retirement: Penn offers generous retirement plans to help you save for your future.

    Penn's Basic, Matching, and Supplemental retirement plans allow you to save for retirement on a pre-tax or Roth basis. Choose from a wide variety of investment options through TIAA and Vanguard.

  • Time Away from Work: Penn provides you with a substantial amount of time away from work during the course of the year. This allows you to relax, take vacations, attend to personal affairs, recover from illness or injury, spend time with family-whatever your personal needs may be.

  • Long-Term Care Insurance: In partnership with Genworth Financial, Penn offers faculty and staff (and your eligible family members) long-term care insurance to help you cover some of the costs of long-term care services received at home, in the community or in a nursing facility.

    If you apply when you're newly hired, you won't have to provide proof of good health or be subject to underwriting requirements. Eligible family members must always provide proof of good health and are subject to underwriting.

  • Wellness and Work-life Resources: Penn is committed to supporting our faculty and staff as they balance the competing demands of work and personal life. That's why we offer a wide variety of programs and resources to help you care for your health, your family, and your work-life balance.

  • Professional and Personal Development: Penn provides an array of resources to help you advance yourself personally and professionally.

  • University Resources: As a member of the Penn community, you have access to a wide range of University resources as well as cultural and recreational activities.

    Take advantage of the University's libraries and athletic facilities, or visit our arboretum and art galleries. There's always something going on at Penn, whether it's a new exhibit at the Penn Museum, the latest music or theater presentation at the Annenberg Center, or the Penn Relays at Franklin Field to name just a few examples. As a member of the Penn community, you're right in the middle of the excitement-and you and your family can enjoy many of these activities for free.

  • Discounts and Special Services: From arts and entertainment to transportation and mortgages, you'll find great deals for University faculty and staff.

    Not only do Penn arts and cultural centers and museums offer free and discounted admission and memberships to faculty and staff. You can also enjoy substantial savings on other goods and services such as new cars from Ford and General Motors, cellular phone service plans, movie tickets, and admission to theme parks.

  • Flexible Work Hours: Flexible work options offer creative approaches for completing work while promoting balance between work and personal commitments. These approaches involve use of non-traditional work hours, locations, and/or job structures.

  • Penn Home Ownership Services: Penn offers a forgivable loan for eligible employees interested in buying a home or currently residing in West Philadelphia, which can be used for closing costs or home improvements.

  • Adoption Assistance: Penn will reimburse eligible employees on qualified expenses in connection with the legal adoption of an eligible child, such as travel or court fees, for up to two adoptions in your household.

To learn more, please visit: https://www.hr.upenn.edu/PennHR/benefits-pay


icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
US EConsulting Database Administrator And Database Migration Specialist Specialist Master CBO AMI

Deloitte

Posted 2 days ago

VIEW JOBS 1/27/2023 12:00:00 AM 2023-04-27T00:00 <p>Position Summary</p><p>Database Administrator and Database Migration Specialist</p><ul><li>Specialist Master</li></ul><p>Help create new life for legacy information technology systems.</p><p>The Deloitte Application Modernization Team - specialists in converting legacy information technology systems to modern languages - is currently seeking a practitioner with hands-on database administration, database migration and modernization experience. This is an exciting opportunity to immerse yourself in one of the hottest areas in the market, moving databases from legacy to modern technologies and into public clouds such as AWS, Azure and GCP.</p><p>Work you'll do</p><p>Responsibilities will include but are not limited to:</p><ul><li>Build</li></ul><ul><li>Design databases, programs, and scripts independently with minimal or no handholding.</li></ul><ul><li>Leadership</li></ul><ul><li>Guide and mentor the junior members of the team.</li></ul><ul><li>Delivery</li></ul><ul><li>Manage and deliver database migration projects for client engagements that identify, design, and implement migration solutions for creative and large businesses. Responsibilities include, among others,</li></ul><ul><li><p>Identification of migration approaches</p></li><li><p>Developing database migration plans for database schema, objects, data, etc.</p></li><li><p>Identifying and creating migration tools and timeline for execution</p></li><li><p>Performing database migration activities e.g., DB2 to PostgreSQL</p></li><li><p>Creating capacity estimates and plans</p></li><li><p>Performance tuning of database and SQL statements to meet business objectives</p></li><li><p>Deployment Activities</p></li></ul><ul><li>Planning and execution for production deployment of the migrated database including deployment activities such as:</li></ul><ul><li><p>Setting up production data server databases as per the architecture diagram i.e., High Availability, Redundancy, Disaster Recovery, etc.</p></li><li><p>Dry runs for data migration of high volume of data within a defined amount of time</p></li><li><p>Data migration from source to target during multiple project phases including System Integration Test, User Acceptance Test, Performance Test, and Production go-live</p></li><li><p>Support post-production database issues during the 60-90 days post go-live and provide client specific training</p></li><li><p>Deliverables</p></li></ul><ul><li>Create and maintain database deliverables such as project schedule, data migration plan, test plan, and database administration guide among others</li></ul><p>The team</p><p>At Deloitte Consulting LLP, Deloitte Application Modernization &amp; Innovation consultants leverage the best of innovative technology, people, and delivery approaches to help our clients dream, explore, build, and optimize their future. The AMI practice delivers end-to-end technology solutions to enable and improve our clients' core business operations. AM&amp;I is composed of three different areas- Service Delivery &amp; Business Design, Application Modernization &amp; Migration and Quality Engineering</p><p>Qualifications</p><p>Required:</p><ul><li><p>Bachelor's degree in Computer Science or similar field or equivalent work experience</p></li><li><p>Minimum of 7 years of relevant work experience</p></li><li><p>Must have demonstrated hands-on experience in at least one of the following technologies:</p></li><li><p>IBM DB2, Oracle, AWS Aurora, PostgreSQL, MySQL or SQL Server</p></li><li><p>Experience in database migration from source database/OS platform to destination database/OS platform.</p></li><li><p>Experience in automation of Database task using DevOps tools such as GitHub.</p></li><li><p>Experience working in a large development environment, both in person and remote, gathering business requirements, assessing, and estimating activities, and assisting developers with SQL performance tuning and other database related activities</p></li></ul><p>Preferred:</p><ul><li><p>Experience working for large consulting firms in client service role</p></li><li><p>Experience working on projects using Agile methodology</p></li><li><p>Cloud platform experience in AWS, Azure or GCP is strongly preferred</p></li></ul><p>Additional Requirements:</p><ul><li><p>Limited Sponsorship: Limited immigration sponsorship may be available</p></li><li><p>Must be willing to travel up to 50%</p></li></ul><p>AppMod2020</p><p>Recruiting tips</p><p>From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters.</p><p>Benefits</p><p>At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you.</p><p>Our people and culture</p><p>Our diverse, equitable, and inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ideas and perspectives, and bring more creativity and innovation to help solve our client most complex challenges. This makes Deloitte one of the most rewarding places to work. Learn more about our inclusive culture.</p><p>Professional development</p><p>From entry-level employees to senior leaders, we believe there's always room to learn. We offer opportunities to build new skills, take on leadership opportunities and connect and grow through mentorship. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career.</p><p>As used in this posting, &quot;Deloitte&quot; means Deloitte Consulting LLP, a subsidiary of Deloitte LLP. Please see www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries.</p><p>All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.</p><p>Deloitte will consider for employment all qualified applicants, including those with criminal histories, in a manner consistent with the requirements of applicable state and local laws. See notices of various ban-the-box laws where available.</p><p>Requisition code: 135415</p><br> Deloitte Philadelphia PA

Database Administrator/Research Analyst, Wharton Real Estate Center

University Of Pennsylvania