Database Administrator

Pico is a rapidly expanding Fintech company that offers innovative, transparent, low-latency markets solutions from a portfolio of best-in-class products coupled with an agile and expert service delivery platform. We help our clients to efficiently scale their business and quickly access global financial markets. From infrastructure to connectivity, we support our clients through the full trading lifecycle. We are a global company headquartered in New York, with various international offices including, London, Dublin, Madrid, Krakow, Singapore and Tokyo.

Job Title: Database Administrator

Corporate Title: AVP

Department: Platform Engineering

Purpose of the role

Pico is currently seeking candidates for our Database Administrator opening. Qualified candidates must be proficient with Microsoft SQL Server and its eco system. Knowledge of other DBMS systems, Operating Systems, Hardware platforms, Cloud technologies, Change Control management and systems plus automation platforms is a plus.

Responsibilities and duties

Database:

• Deploy and manage enterprise and Pico managed database platforms
• Maintain, administer, troubleshoot, install, and configure database systems
• Deploying/Implementing database security best practices
• Performance and optimization of databases and database servers
• Performance tuning of SQL and TSQL statement/procedures
• Provide criteria, requirements, and solutions around database monitoring
• Assist with the certification, upgrading and patching of all database products
• Support existing DB processes and procedures autonomously

DevOps:

• Automation of operational tasks
• Automated custom report generation for proprietary systems

Requirements:

Required Database Experience/Knowledge:

• Microsoft SQL Server
  • 2025, 2022 and 2019
  • Geo-clustering, AlwaysOn Availability, & Replication, CDC
• Design for optimised queries
• Database encryption
• Database object modelling
• Database High Availability and Disaster Recovery solutions
• TSQL coding

Optional (Plus) Database Experience:

• MongoDB
• MySQL (Innodb a plus)
• PostgreSQL

Preferred DevOps skills:

• OS Experience in Windows
  • Server Configuration
  • Monitoring
  • Server Applications
  • Services
  • Scheduled Jobs
  • clustering
• Scripting
  • SQL, TSQL, SQLCMD,
  • PowerShell a plus

Optional DevOps skills:

• Docker and Kubernetes
• OS Experience in RedHat Linux
  • DBA in Linux eco system
  • Troubleshooting
  • Monitoring
• Scripting
  • Python a plus
  • Bash a plus
  • Ansible a plus

Soft skills:

• 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

Working Arrangements

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.

IMPORTANT DATA PRIVACY INFORMATION:

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.