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 Databases 

 

Preferred 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 Environments 

Experience 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