Send me more jobs like this

Keywords / Skills : SQL server replication, Always ON, Performance Tuning, SQL Programming, T-SQL, log shipping, Mirroring, clustering, back up, recovery model, linux

4 - 7 years
Posted: 2019-06-13

Nationality
India
Industry
Banking/Accounting/Financial Services
IT/Computers - Software
Function
IT
Role
Systems Engineer
Education
Any graduate
Posted On
13th Jun 2019
Job Description
Who We Are:

ThoughtFocus is a privately held IT services, software engineering and business process management firm with offices in the US, India and the Philippines. It helps clients in the financial services, manufacturing, education, aerospace and technology industries with their key business and technology challenges. ThoughtFocus brings critical program acceleration to client initiatives while minimizing costs and risks with intellectual capital, technical and process frameworks, operating models and software infrastructure

It has 1,300+ employees globally and is growing rapidly across all its offices. In the US ThoughtFocus has locations in California, New York, New Jersey, Wisconsin, Georgia and Texas.

As an organization, ThoughtFocus strives to build lasting relationships. ThoughtFocus was founded in 2004 and continues to be an employee owned company with a minority investment from the Blackstone Group.

Job Description

This position will be responsible for the implementation, configuration, maintenance, and performance of critical RDBMS and No-SQL systems, to ensure the availability and consistent performance of our databases. This is a "hands-on" position requiring solid technical skills, as well as excellent interpersonal and communication skills.

The successful candidate will be responsible for the development and sustainment of SQL Server, PostgreSQL, MongoDB and MariaDB/MySQL environments, ensuring its operational readiness (security, health and performance), executing data loads, and performing data modeling in support of multiple development teams. Must be capable of working independently and collaboratively.

Responsibilities

• Manage databases through multiple product lifecycle environments, from development to mission-critical production systems.

• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

• Apply data modeling techniques to ensure development and implementation support efforts meet integration and performance expectations

• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end.

• Refine and automate regular processes, track issues, and document changes

• Write new scripts and refine existing once.

• Assist developers with complex query tuning and schema refinement.

• Provide 24x7 support for critical production systems.

• Perform scheduled maintenance and support release deployment activities after hours.

• Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members. 

Skills and Qualifications

• 4+ years MS SQL Server Administration experience required

• 1+ years MongoDB administration experience is a plus

• 1+ years PostgreSQL administration experience is a plus

• Expert knowledge required in SQL Server replication, Always-ON, performance tuning and optimization, troubleshooting and SQL Server internals.

• Expert level experience with backups, restores and recovery models

• Hands-on on other HA/DR topologies like Log Shipping, Mirroring and Clustering for SQL Server

• Expert in writing and troubleshooting T-SQL

• Experience working with Windows server, including Active Directory

• Experience working with Linux and any scripting language like powershell, shell, python etc..

• Experience in PostgreSQL & MariaDB/MySQL installation, backup, restore, recovery, setting up security, replication and troubleshooting.

• Experience in MongoDB installation, CRUD operations, backup, restore, recovery, security best practices, replication and sharding.

• Excellent written and verbal communication

• Flexible, team player, "get-it-done" personality

• Ability to organize and plan work independently

• Ability to work in a rapidly changing environment

• Ability to multi-task and context-switch effectively between different activities and teams

• MCTS, MCITP, and/or MVP certifications a plus

Life at ThoughtFocus:

ThoughtFocus is a global company that brings together skilled professionals from many diverse industries and experiences. Within a broad framework of teamwork, knowledge sharing, and collaboration, we encourage our associates to achieve and excel in ways they may never have imagined for themselves.

Solving complicated client problems requires great people. ThoughtFocus is a firm built on the talent of its people. We work hard every day to nurture and expand the capabilities of our team members. As a member of the ThoughtFocus team you will be challenged every day to deliver innovative business solutions, elegant technology, and sophisticated business services focused on our client’s end goals.

Affirmative Action Statement:

ThoughtFocus 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.



About Company

ThoughtFocus is a leading US based IT and BPO services provider. It is ISO 9001/2015 certified and provides consulting, product engineering and applications development besides BPO services. ThoughtFocus operates globally from three countries and has eight US locations, three locations in India and one in the Philippines. ThoughtFocus has a team of 1,500+ associates that help organizations across the globe realize their business-driven technology initiatives. Its solutions encompass innovative ways of aligning business with technology, creating an integrated, company-wide platform supporting enterprise goals.

The global team at ThoughtFocus is a diverse mix of people from different countries, backgrounds and areas of expertise. Working at ThoughtFocus requires you to be comfortable in a high-energy environment where collaboration is the norm, not the exception. We expect our employees to be self-starters who constantly look for opportunities to grow their own skills and improve the company. If you have the ability to excel in a fast moving global company, ThoughtFocus is the place for you.

Within a broad framework of teamwork, knowledge sharing, and collaboration, we encourage our associates to achieve and excel in ways they may never have imagined for themselves. We value outstanding performance and provide our associates with well-defined career paths.

The best source of information about ThoughtFocus is our corporate website: www.thoughtfocus.com.
Similar Jobs
View All Similar Jobs


Walkin for you