We are looking for skilled candidate who is enthusiastic about learning new and existing technologies in order to deliver exceptional solutions for the production resiliency of the systems. The role incorporates aspects of software engineering and operations. The Database SME will be responsible for supporting Oracle/ **MongDB/PostgresSQL/Couchbase** for Database as a Service (DBaas) team. Understand the end-to-end configuration, technical dependencies, and overall behavioral characteristics of production services. Responsible for the design and delivery of the mission critical stack, with focus on security, resiliency, scale, and performance. Understand and communicate the scale, capacity, security, performance attributes, and requirements of the service and technology stack. Utilize a deep understanding of service topology and their dependencies required to troubleshoot issues and define mitigation's.


**Responsibilities** **:**


+ **Senior** **Oracle/MongoDB/MSSQL/PostgreSQL/Couchbase** **SME to support critical Citi businesses**

+ Implement , setup and maintain MongoDB OPS Manager/Cloud Manager. Design and implement HA/DR policies.

+ Design/build for OEM environments, with OEM 13c experience preferred.

+ Experience in Oracle 12c, 19c

+ Extensive experience with features such as Oracle Real Application Clusters (RAC), ASM and Active Data Guard for HA and DR solutions, Golden Gate and other replication methods, TDE and other security products, and other advanced oracle features in Linux environment.

+ Extensive experience diagnosing complex technical issues with DBs, storage, networks in a production environment

+ Documentation skills for processes and procedures (creating KBs, run-books etc.)

+ **Experience with performance and troubleshooting on** **MongoDB/MSSQL/PostgresSQL/Oracle/Couchbase** **Databases**

+ Create complex project plans, perform impact analyses, solve/work high impact problems/projects, and provide resolution to restore services

+ Provide Root Cause Analysis (RCA) post restoration of service

+ Design testing approaches, complex processes, reporting streams, and assist with the automation of repetitive tasks

+ Provide technical/strategic direction to team members.

+ Design testing approaches, complex processes, reporting streams, and assist with the automation of repetitive tasks

+ Review requirement documents, define hardware requirements and update processes and procedures as necessary

+ Ensure ongoing compliance with regulatory requirements

+ Responsible for applications dealing with the overall operating system

+ Conduct project related research

+ Has the ability to operate with a limited level of direct supervision.

+ Can exercise independence of judgement and autonomy.

+ Acts as SME to senior stakeholders and /or other team members.

+ 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:**


+ **Strong experience of MongoDB and Oracle, MSSQL and** **PostgresSQL/Couchbase** **databases.**

+ 5+ years of hands-on experience with MongoDB scaling across data centers and/or in-depth understanding of MongoDB HA strategies, including replica sets and sharding.

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

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

+ **Experience with Actifio is a plus**

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

+ 3+ years of experience in design/build for OEM environments, with OEM 13c preferred.

+ 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


**Education:**


+ Bachelors/University degree, Masters degree preferred


-------------------------------------------------


**Job Family Group:**


Technology

-------------------------------------------------


**Job Family:**


Infrastructure

------------------------------------------------------


**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 (https://www.citigroup.com/citi/accessibility/application-accessibility.htm)** .


View the "EEO is the Law (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/eeopost.pdf) " poster. View the EEO is the Law Supplement (https://www.dol.gov/sites/dolgov/files/ofccp/regs/compliance/posters/pdf/OFCCP\_EEO\_Supplement\_Final\_JRF\_QA\_508c.pdf) .


View the EEO Policy Statement (http://citi.com/citi/diversity/assets/pdf/eeo\_aa\_policy.pdf) .


View the Pay Transparency Posting (https://www.dol.gov/sites/dolgov/files/ofccp/pdf/pay-transp\_%20English\_formattedESQA508c.pdf)
Citi is an equal opportunity and affirmative action employer.
Minority/Female/Veteran/Individuals with Disabilities/Sexual Orientation/Gender Identity.