Cloud Database Specialist - VP - Hybrid

The Engineering Lead Analyst is a senior level position responsible for leading a variety of engineering activities including the design, acquisition and deployment of hardware, software and network infrastructure in coordination with the Technology team. The overall objective of this role is to lead efforts to ensure quality standards are being met within existing and planned framework.

Responsibilities:

• Serve as a technology subject matter expert for internal and external stakeholders and provide direction for all firm mandated controls and compliance initiatives, all projects within the group and in creating a technology domain roadmap
• Ensure that all integration of functions meet business goals
• Define necessary system enhancements to deploy new products and process enhancements
• Recommend product customization for system integration
• Identify problem causality, business impact and root causes
• Exhibit knowledge of how own specialty area contributes to the business and apply knowledge of competitors, products and services
• Advise or mentor junior team members
• Impact the engineering function by influencing decisions through advice, counsel or facilitating services
• Appropriately assess risk when business decisions are made, demonstrating particular consideration for the firm's reputation and safeguarding Citigroup, its clients and assets, by driving compliance with applicable laws, rules and regulations, adhering to Policy, applying sound ethical judgment regarding personal behavior, conduct and business practices, and escalating, managing and reporting control issues with transparency.

Qualifications:

• 8-12 years of relevant experience in an Engineering role
• Experience working in Financial Services or a large complex and/or global environment
• Project Management experience
• Consistently demonstrates clear and concise written and verbal communication
• Comprehensive knowledge of design metrics, analytics tools, benchmarking activities and related reporting to identify best practices
• Demonstrated analytic/diagnostic skills
• Ability to work in a matrix environment and partner with virtual teams
• Ability to work independently, multi-task, and take ownership of various parts of a project or initiative
• Ability to work under pressure and manage to tight deadlines or unexpected changes in expectations or requirements
• Proven track record of operational process change and improvement

Education:

• Bachelor's degree/University degree or equivalent experience
• Master's degree preferred

Cloud database specialist is for DBaaS (Database as a Service) cloud platform. Primarily responsible for DBaaS operations on OraaS (Oracle as a Service), MaaS (MongoDB as a Service), MSaaS (MS-SQL as a Service).

Strong experience of Oracle, PostgreSQL, MongoDB and MS-SQL databases.

10 + years of hands-on experience with Oracle, MongoDB, MS-SQL across data centers and/or in-depth understanding of Oracle RAC including ASM, Dataguard, SQLT, Grid infrastructure, AWR/ASH, AHF, OMS, OEM and Plugin DB

8+ years of experience in administration of OEM, MongoDB Ops Mgr setup, Monitoring , Backup and Automation.

10+ years production Oracle Database Administration experience with RAC, ASM and RMAN.

Strong Knowledge and experience in Cloud operations , As a Service architectures,
Experience with ACTIFIO is an added advantage
Expertise in MongoDB installation, deployment and upgrade procedures including public clouds.
Expertise in MongoDB database performance tuning and Query optimization.
Exposure to infrastructure and platform capabilities - container, middleware, messaging, routing components
Expertise in MongoDB HA and Scalable Architecture.
Comfortable in using MongoDB tools like, mongostat, mongotop, mongoexport, mongoimport, mongodump, mongorestore etc. Database Security management and User Management.
5+ years of experience in installing , configuring and managing Windows Server 2012/2016/2019
Expertise in Windows PowerShell commands and scripting.
Exposure to Windows Server CORE.
Experience in creating and managing Windows Server Failover Clusters.
Skilled in troubleshooting BSOD and performing Crash dump analysis
Experience on VMware technologies like ESXi, vSphere systems administration and support, including vMotion, HA, DRS, vCenter Operations Manager, vCenter Update Manager and Site Recovery Manager
Adequate exposure to any public cloud based deployments (IaaS and PaaS), AWS/GCP/Azure
Strong knowledge of MS SQL Server 2012/2014/2016 and 2019 environments database administration in Windows and virtual environments
Experienced in implementation of HA options like Log Shipping, Mirroring and Replication and Clustering options for SQL Server
Expert in writing T-SQL, including complex stored procedures, functions, views and triggers
Experience with High Availability (HA) and Disaster Recovery (DR) options for SQL Server
Experience in Performance Tuning and Query Optimization for Oracle/MSSQL/MongoDB
Having Experience in SQL AlwaysON
Having Experience in SQL server service pack and security patches installation.
Having Experience in Oracle/MongoDB/SQL migration and purgation.
Good Experience in scheduling SQL Server Agent Jobs, Alerts and automating scripts.
Strong knowledge of backups, restores, recovery models, database shrink operations, DBCC commands, Database mirroring, Replication.
Having knowledge of Profiler, DTS, SSIS packages and experience in SSAS, SSRS
Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space and other resource contention.
Proficient with automation technologies such as Microfocus DMA,
Understand internet networking services, such as DNS, HTTP, etc.
Programming and scripting languages (Python, bash, Java Script - additional experience with PHP, Groovy, Java, and/or Go is a plus).
Using Ci/CD scripting tools such as Ansible, Puppet, or Chef.
Containers and orchestration (Docker, Kubernetes, and docker-compose).
Preferred experience with GIT, GITFlow, JIRA, Confluence and Agile frameworks.
Knowledge of IP networking including TCP, UDP, DNS, DHCP, firewalls, IP routing, etc.
Must have a solid understanding of latest web technologies (TCP/IP, HTTP, HTML, JavaScript, CSS), REST, SOAP, XML, JSON and other relevant API standards like OAuth, SAML.
Ability to develop projects required for design of metrics, analytical tools, benchmarking activities and best practices
Ability to work with virtual / in-person teams, and work under pressure / to a deadline
Experience in a Financial Services or large complex and/or global environment preferred
Effective written and verbal communication skills
Effective analytic/diagnostic skills
Ability to communicate technical concepts to non-technical audience

Job Family Group:
Technology

Job Family:
Systems & Engineering

Time Type:
Full time

Citi is an equal opportunity and affirmative action employer.

Qualified applicants will receive consideration without regard to their race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.

Citigroup Inc. and its subsidiaries ("Citi") invite all qualified interested applicants to apply for career opportunities. If you are a person with a disability and need a reasonable accommodation to use our search tools and/or apply for a career opportunity review Accessibility at Citi .

View the " EEO is the Law " poster. View the EEO is the Law Supplement .

View the EEO Policy Statement .

View the Pay Transparency Posting