Staff Site Reliability Engineer - Database Management (Microsoft SQL Server)

Job Description And Responsibilities

We are part of the Staff Site Reliability Engineering team which delivers operationally excellent open system database infrastructure.

We are the industry leader in preventative and predictive operations driven by continuous innovation through

self-healing and automated ecosystems. We design, engineer and build reliable, scale-able, secure, available and cost-effective database infrastructure solutions for our product development partners with whom we work closely.

This is why technical expertise and people skills are important. Members of this team are the technology owners of multiple RDBMS and NoSQL technologies which means if you join us, you will also be responsible to strategize, advance, and engineer enterprise solutions for automated build patching and efficient administration that meets security, availability, performance, fast delivery and reporting requirements, and to support projects and products using these technologies.

As an engineer on this team, you will be involved in the Plan, Build, and Run aspects of the database technologies, translating into architecture, engineering, and operational support.

Essential Functions :

Primarily Database reliability engineering, deployment, and support of MSSQL database technology which include both on premise and cloud environments such as AWS and GCP.

Support Database Administration and Engineering in the design, development and deployment, and management of Microsoft SQL database environments.

This includes the advanced to expert engineering and implementation of the following :

• Collaborate with all interested parties, gather requirements, and provide recommendation for database standards.
• Provide technical expertise to design the most efficient and cost-effective solutions for Microsoft SQL Servers.
• Install, configure, monitor, upgrade and maintain MSSQL databases in production and nonproduction environments.
• Write, Develop, and maintain PowerShell and TSQL scripts for DB automation and application maintenance tasks.
• Advance experience with automation of managerial and repetitive DBA tasks.
• Work closely with other Infrastructure operations and engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA's and performance target set.
• Provide technical expertise and hands-on support in consolidation and migration of databases to new hardware and platforms.
• Implementation and Support of databases, storage structures, high-availability solutions, replication, encryption, and disaster recovery solutions.
• Manage, support, and maintain Microsoft SQL Server database technology and infrastructure, adhering to the architectural guidelines and policies.
• Database administration for off the shelf and internally developed applications, ensure continuous 24x7 operation and availability in support of mission critical business applications and participating in On-Call support.
• Regular database capacity planning and archival solution related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.
• Provide DBA support for enterprise monitoring, backup, alerting, and security compliance solutions for SQL servers.
• Participate in the evaluation, selection, and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing.
• Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues.

This is a hybrid position. Hybrid employees can alternate time between both remote and office. Employees in hybrid roles are expected to work from the office 2-3 set days a week (determined by leadership / site), with a general guidepost of being in the office 50% or more of the time based on business needs.

Qualifications

Basic Qualifications :

5+ years of relevant work experience with a Bachelor’s Degree or at least 2 years of work experience with an Advanced degree (e.

g. Masters, MBA, JD, MD) or 0 years of work experience with a PhD, OR 8+ years of relevant work experience.

Preferred Qualifications :

6 or more years of work experience with a Bachelors Degree or 4 or more years of relevant experience with an Advanced Degree (e.

g. Masters, MBA, JD, MD) or up to 3 years of relevant experience with a PhD Computer Science or other technology field.

• 8-10 years of DBA experience with Microsoft SQL Server databases.
• 2+ Years of experience working on SQL Server on Linux platforms.
• Strong technical skills in TSQL and PowerShell programming to automate SQL Server operational repetitive tasks.
• 2+ years of experience in managing team of size minimum of 3+ and working with Global teams is a plus for this position.
• Strong knowledge and extensive experience with Microsoft SQL server technologies (all core areas : SSMS, SQL clustering, Data Synchronization, Encryption, Partitioning, Performance, Security, SSAS, SSIS and SSRS configuration) is mandatory.
• Sound knowledge of all windows and SQL utilities, strong PowerShell knowledge and experience is a plus.
• Solid understanding of network, storage, tiered application environments and security.
• Solid knowledge in database replication technologies including Always-on, Goldengate, etc. and strong site reliability engineering skills to design systems that meet various applications High Availability and Disaster Recovery requirements.
• Have good experience in engineering processes supporting repetitive or frequent tasks in database administration or deployment.
• Solid understanding and experience in maintain MSSQL technology lifecycle, and automation of MSSQL deployment.
• Good engineering skills in developing enterprise solutions to support MSSQL in areas like backup, monitoring and alerting, security compliance, patching, etc.
• Good interpersonal skills along with effective communication (both written and verbal) skills.
• Demonstrate ability to solve complex systems and database environment issues.
• Demonstrate ability to work in a complex organization to determine business and customer needs, providing the best solution to meet those needs.
• A good team player, leader, flexible, share knowledge, help others, collaborate well within and outside the team.
• Programming languages Python or C++ is plus for this position.
• Work experience in a Financial Institute will be preferred.
• Ability to work well as a team and as an individual with minimal supervision.

Additional Information

Work Hours : Varies upon the needs of the department.

Travel Requirements : This position requires travel 5-10% of the time.

Mental / Physical Requirements : This position will be performed in an office setting. The position will require the incumbent to sit and stand at a desk, communicate in person and by telephone, frequently operate standard office equipment, such as telephones and computers.

Visa is an EEO Employer. Qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, sexual orientation, gender identity, disability or protected veteran status.

Visa will also consider for employment qualified applicants with criminal histories in a manner consistent with EEOC guidelines and applicable local law.

Visa will consider for employment qualified applicants with criminal histories in a manner consistent with applicable local law, including the requirements of Article 49 of the San Francisco Police Code.

U.S. APPLICANTS ONLY : The estimated salary range for a new hire into this position is 119,100.00 to 172,600.00 USD per year, which may include potential sales incentive payments (if applicable).

Salary may vary depending on job-related factors which may include knowledge, skills, experience, and location. In addition, this position may be eligible for bonus and equity.

Visa has a comprehensive benefits package for which this position may be eligible that includes Medical, Dental, Vision, 401 (k), FSA / HSA, Life Insurance, Paid Time Off, and Wellness Program.