Overview
Senior Database Analyst – Microsoft SQL
Responsibilities
Support and Administer Microsoft SQL Databases for applications in team's support scope.
Assist developers and testers with troubleshooting and recommendations, including but not limited to performance and functionality.
Respond to outages of the database environments and correct issues.
Migrate Databases between private datacenters, public cloud platforms, and database and hosting types
Routinely patch and upgrade databases to ensure security of platforms
Backup Databases to ensure proper redundancy within RPO/RTO requirements
Manage, Monitor, and Maintain Database Production Environments to ensure maximum availability and performance.
Provide Performant, Resilient, and Cost-Effective Solution Designs and Architecture for Pearson solutions requiring a database on the private, and the public cloud
Qualifications
BS degree in Computer Science or related technical field involving systems engineering (e.g., physics or mathematics), or equivalent practical experience.
6+ Years Experience Supporting and Administering Microsoft SQL DatabasesPreferred Qualifications
3+ years experience administering applications and software in Linux command-line environment (OEL/RHEL 6.x/7.x/8.x preferred), including ability to use Linux commands and tools to troubleshoot issues, parse and evaluate log files and ability to write and revise bash scripts 6+ years experience administering applications and software in Microsoft Windows EnvironmentsExperience in T-SQL, PowerShell, SQL Server Replication, and modern MSSQL database design.
Basic Networking Experience, including routing, ports, and firewall concepts
Experience with systems and software engineering/development concepts and techniques
Automation and Scripting Experience to deploy, configure, and administer database services
Experience with Amazon Web Services or Azure including DBaaS (i.e. RDS / Azure SQL) and IaaS (i.e. EC2/Azure VMs) is a plus.
Experience with other Database types, including MySQL, Oracle, and NoSQL is a plus.
Able to interact professionally with customers, developers, and colleagues
Excellent written and verbal communication skills
Who we are:
At Pearson, our purpose is simple: to help people realize the life they imagine through learning. We believe that every learning opportunity is a chance for a personal breakthrough. We are the world's lifelong learning company. For us, learning isn't just what we do. It's who we are. To learn more: We are Pearson.
Pearson is an Affirmative Action and Equal Opportunity Employer and a member of E-Verify. We want a team that represents a variety of backgrounds, perspectives and skills. The more inclusive we are, the better our work will be. All employment decisions are based on qualifications, merit and business need. All qualified applicants will receive consideration for employment without regard to race, ethnicity, color, religion, sex, sexual orientation, gender identity, gender expression, age, national origin, protected veteran status, disability status or any other group protected by law. We strive for a workforce that reflects the diversity of our communities.
If you are an individual with a disability and are unable or limited in your ability to use or access our career site as a result of your disability, you may request reasonable accommodations by emailing TalentExperienceGlobalTeam@grp.pearson.com.
Note that the information you provide will stay confidential and will be stored securely. It will not be seen by those involved in making decisions as part of the recruitment process.
Job: TECHNOLOGY
Organization: Corporate Strategy & Technology
Schedule: FULL\_TIME
Workplace Type:
Req ID: 19247
- 3 - 6 Yrs
- Noida
- 7 - 12 Yrs
- Mumbai
- Mumbai, Maharashtra, India
- Mumbai, Maharashtra, India