Roles & Responsibilities

JD

Our client is a US multinational financial services corporation that facilitates electronic funds transfers throughout the world. They are a trusted network and world leader in digital payments, working to remove barriers and connect more people to the global economy.

About this Role

• Primarily the architecture, engineering, deployment and support of MSSQL database technology.
• Support Database Administration and Engineering in the architecture, 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 non-production environments.
• 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/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.
• 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.

REQUIREMENTS

• Bachelors/Degree in Computer Science or other technology field is a must.
• 6-8 years of DBA experience with Microsoft SQL Server.
• 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, Golden Gate, SQL Server Native replication P2P etc. and strong architectural/engineering skills to design systems that meet various applications High Availability and Disaster Recovery requirements.
• Strong technical skills in TSQL and PowerShell programming to automate SQL Server operational repetitive tasks
• Programming languages Python or C++ is plus for this position
• 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.
• Solid understanding of active-active HADR deployments using SQL Server Replication technologies
• 5+ years of experience in working with SQL Server Native replication like P2P and Transactional replication.
• 4+ years of experience in SQL Server Always on Clustering technologies
• Good engineering skills in developing enterprise solutions to support MSSQL in areas like backup, monitoring/alerting, security compliance, patching, etc.
• Good interpersonal skills along with effective communication (both written and verbal) skills.

Short Listed Candidates will be Notified & Contacted.

PrimeStaff Management Services Pte Ltd

EA License No.: 95C5411

EA Personnel Reg. No.: R23112467

Tell employers what skills you have

Technical Operations
Consolidation
High Availability
Microsoft SQL Server
Microsoft SQL
Tuning
Replication
Production Support
SQL
Database Administration
SQL Server
Architecture Design
Windows
Encryption
SSIS
Disaster Recovery
Databases