Database Administrator
- PayPal
- 1 to 2 Yrs
- Bengaluru
- 5 years ago
- Email to a friend
- Report this job
Job Description
We have instituted the Technology Efficiency program as one of key strategic programs for the Business Technology Office under the CTO. The program measures impact, cost, and operational efficiencies of our physical technology infrastructure, thousands of applications used to run PayPal, and the processes that govern IT. The team managing this program performs detailed analytics using data from multiple data sources / monitoring tools to identify inefficiencies and work within the organization to communicate / remediate them.
The efficiency program is a key priority for 2021 and the team is rapidly growing its area of responsibilities . We are seeking motivated applicants for a Database Administrator position to manage the data-mart used to perform the efficiency analytics and help the team scale to become an enterprise-wide product.
Core Duties
- Manage the day-to-day operation of the efficiency database to ensure availability and performance
- Perform weekly data load activities including monitoring automated jobs, troubleshooting errors, and coordinating with team members for any manual data gathering
- Performs root cause analysis for any db query or data load issues. Resolves problems and recommends solutions
- Ensure proper data archives and backups are taken on a regular basis and are accessible should they be needed
- Evaluate large and complex queries / stored procedures and recommend changes to optimize performance
- Ensure DB server is patched and manage upgrades of database every 1-2 years as dictated by enterprise policy
- Assist other team members with query development as needed
- Maintain data dictionary and technical documentation for DB schema
Competencies
Core Behavioral Competencies
- Strong written and verbal communication skills
- Ability to write clear and concise communications
- Ability to work effectively in a global team environment
Role Specific Behavioral Competencies
- Ability to translate complex problems into simpler terms
- Ability to work independently
Prerequisite Knowledge & Proficiencies
Must Have
- Proficient in Microsoft SQL Server 2016 & 2019 Database Development (T-SQL), Data Analysis and Support.
- Thorough understanding of RDBMS concepts and ability to write complex SQL queries, Stored procedures, Functions & triggers
- Proficiency with python scripting language
- Familiarity with MS Word, Excel & Visio knowledge needed
- Experience writing and maintaining technical documentation
Nice to Have
- Knowledge of data backup, recovery, security, integrity
- Experience managing database upgrades / data migrations
- Design and implementation of ETLs from various source systems
- Experience optimizing queries
Experience & Education
- 2+ years of working experience as a Database Administrator
- BS in Computer Science, Information Systems, or equivalent
Examples of Specific Job Tasks/Accountabilities
- Monitor jobs used to load analytics data weekly into the DB and manually load data sets not yet automated
- Track errors with data loads or ETLs and remediate them. Ensure data is refreshed within 1-2 days each week so that the dashboard with updated data can be reviewed with the team
- Create, update, maintain documentation on DB schema and data dictionary for fields
- Build / optimize queries needed by team as needed
- Track data quality / integrity issues with the db and report them
We're a purpose-driven company whose beliefs are the foundation for how we conduct business every day. We hold ourselves to our One Team Behaviors which demand that we hold the highest ethical standards, to empower an open and diverse workplace, and strive to treat everyone who is touched by our business with dignity and respect. Our employees challenge the status quo, ask questions, and find solutions. We want to break down barriers to financial empowerment. Join us as we change the way the world defines financial freedom.
PayPal provides equal employment opportunity (EEO) to all persons regardless of age, color, national origin, citizenship status, physical or mental disability, race, religion, creed, gender, sex, pregnancy, sexual orientation, gender identity and/or expression, genetic information, marital status, status with regard to public assistance, veteran status, or any other characteristic protected by federal, state or local law. In addition, PayPal will provide reasonable accommodations for qualified individuals with disabilities. If you are unable to submit an application because of incompatible assistive technology or a disability, please contact us at pa**************************n@pa***l.com.
R0062333
,
Employement Category:
Employement Type: Full timeIndustry: Internet / E-CommerceRole Category: Network / System AdministrationFunctional Area: Not ApplicableRole/Responsibilies: Database AdministratorContact Details:
Company: PayPal Holdings IncLocation(s): Bengaluru
PayPal
PayPal Holdings, Inc. is an American company operating a worldwide online payments system. Online money transfers serve as electronic alternatives to traditional paper methods like checks and money orders
Job Listings
We are in open beta version of website, please let us know if any issues, at: info(at)indigojobs.in