Pico1mo ago

Database Administrator

India·Punemid

DevOps & InfrastructureDatabase AdministratorData & AI

5 views0 saves0 applied

Apply Now

Quick Summary

Overview

Requirements Summary

Required Database Experience/Knowledge: Microsoft SQL Server 2025, 2022 and 2019 Geo-clustering, AlwaysOn Availability, & Replication, CDC Must have Microsoft Windows Server management skills Must be familiar with using Powershell Design for…

Technical Tools

ansibledockerkubernetesmongodbmysqlpostgresqlpythonsqllinuxperformance-optimizationsecurity-best-practices

Pico fuels the global capital markets community by providing exceptional market data services and customized managed infrastructure solutions. As financial industry experts at the center of markets and technology, we help our clients efficiently scale their business and quickly access markets. From infrastructure to connectivity, we support our clients through the full trading lifecycle. We are a global company headquartered in New York, with offices in Chicago, London, Singapore, Hong Kong and Tokyo.

Pico is currently seeking candidates for our Database Administrator opening. Qualified candidates must be proficient with Microsoft SQL Server and it’s supporting eco system. Candidates are expected to be competent in Microsoft Windows Server, Powershell and will be required to perform basic Windows and SQL software management without assistance. Highly qualified candidates will have a working knowledge of multiple DBMS platforms and will be expected to demonstrate a knowledge of at least one other DBMS platform. Experience with Linux, Hardware selection and sizing, Cloud technologies, Change Control management and automation are a plus.

Responsibilities

~1 min read

Deploy database platforms in a repeatable manner through scripting and automation
Manage and maintain database platforms for Pico and our clients
Maintain, administer, troubleshoot, install, and configure database systems
Implement database security best practices
Performance optimization of databases and the supporting ecosystem
Performance tuning of SQL and TSQL statement/procedures
Provide criteria, requirements, and solutions for database monitoring within the framework of Pico’s existing monitoring systems
Assist with the certification, upgrading and patching of all database products
Support existing DB processes and procedures autonomously

Automation of operational tasks
Automated custom report generation for proprietary systems

Requirements

~1 min read

Microsoft SQL Server

2025, 2022 and 2019
Geo-clustering, AlwaysOn Availability, & Replication, CDC
Must have Microsoft Windows Server management skills
Must be familiar with using Powershell

Design for optimised queries
Database encryption
Database object modelling
Database High Availability and Disaster Recovery solutions
TSQL coding

MongoDB
MySQL (Innodb a plus)
PostgreSQL

Nice to Have

~1 min read

OS Experience in Microsoft Windows

Server Configuration
Monitoring
Server Applications
Services
Scheduled Jobs
Clustering
Patching

Scripting

SQL and SQLCMD

RedHat Linux

Basic Linux user skills
DBMS on Linux: Installation, Support, Troubleshooting and Monitoring

Docker and Kubernetes
Scripting

Python, Bash or Ansible a plus

Ability to write clear and concise documentation
Ability to plan complex tasks into effective project timelines
Ability to communicate effectively at all levels either internally or with external clients and vendors

This position is based out of Singapore/India. Though travel may be required from time to time, it is not expected to be regular or frequent. The role holder will be expected to work whatever hours are necessary for the performance of this role (recognizing that it involves multiple jurisdictions / geographies including EMEA and AMRS). This will include scheduled weekend work.

This position is available with Pico Technology India Private Limited . The controller of your personal data will be Pico Technology India Private Limited.

For further information on what personal data we collect, how we will process your personal data and your rights with respect to your personal data please read our Pico Job Candidate Privacy Notice, View Here.

Be a part of Pico Family

Pico is an equal opportunity employer. Pico does not discriminate on the basis of a candidate's age, race, gender, color, religion, sexual orientation, physical or mental disability, or other non-merit factors. All employment decisions at Pico are based on business needs, job requirements and qualifications. If you require any assistance or accommodations to be made for the recruitment process, please inform us when you submit your online application.