Senior Mongodb Dba/architect Resume
2.00/5 (Submit Your Rating)
Englewood Cliff, NJ
SUMMARY
- Ensure continuous availability of mission critical MongoDB clusters.
- Disaster recovery strategies and regular recovery test o Schema design and access patterns
- Implement and configure Amazon AWS and Microsoft Azure multi - region replica set replication/sharding
- Configure MongoDB instances in Linux VM, Docker containers and Windows platforms in on-prem, Amazon AWS and Microsoft Azure cloud environments
- Configure and deploy a highly available Ops Manager application including filesystem backup database Ops Manager monitoring, alert, automation, backup and restore Capacity Planning and Hardware Provisioning o Automate routine tasks using Linux shell scripts
- Capacity planning, tuning, autantication, authorization o Performance tuning and indexing strategies
- Configure security including SSL, LDAP and Kerberos autantication/authorization; and encryption at rest User management and standards Train and guide staff on MongoDB best pactices Application Development team support
- Deployed and install Datastax Cassandra DB including OpCenter
- Strong in SQL Queries/RDMS (DB2, Teradata, Oracle PL/SQL, Sybase)
- Experience in Data Warehousing, ETL and Data Mining
- Strong experience in brokerage, financial and securities applications
- TEMPEffective organizational and communication skills
- Strong sense of responsibility and self-motivation
- Able to work in a team and as individual
TECHNICAL SKILLS
- MongoDB, Cassandra, DB2, Teradata, Sybase, Oracle PL/SQL, Python, Java, Cobol, CICS, Windows, Linux, Docker, MVS, Base SAS, MQ Series, Business Analysis, Data Modeling, SDLC, Agile
PROFESSIONAL EXPERIENCE
Confidential, Englewood Cliff, NJ
Senior MongoDB DBA/Architect
Responsibilities:
- Configure and deploy MongoDB clusters (ver 3.2) provisioned as DBaaS
- Configure and deploy a highly available Ops Manager application and filesystem backup database
- Deploy backup and restore strategies using Ops Manager
- Monitoring and automation using Ops Manager
- Configure security including LDAP proxy autantication
- Troubleshooting and performance tuning
- Provide and implement MongoDB SOP and best pratices
- Configure and deploy Cassandra DB (ver 5.0.4) clusters
- Configure and deploy OpsCenter
- Monitoring and automation using OpsCenter
- Deploy backup and restore strategies using OpsCenter
Confidential
Senior MongoDB DBA/Architect
Responsibilities:
- Ensure the continuous availability of our mission critical MongoDB clusters.
- Disaster recovery strategies and regular recoveribility test
- Microsoft Azure multi-region replica set replication
- Automate routine tasks using Linux shell scripts
- Capacity planning, tuning, autantication, authorization
- Ops Manager monitoring, alert, automation, backup and restore performance tuning and indexing strategies configuration and installation of MongoDB Ops Manager in Test, QA and Prod including setup of alerts, authorization and backup processes
- Educate and guide staff about the MongoDB best pactices
Confidential, New York City, NY
Senior Analyst/Developer/Administrator
Responsibilities:
- Implemented the loading of Monthly Statements to MongoDB. Developer and administrative tasks include data modeling and schema design o development using Python and testing configuration, installation and deployment to Dev, QA and Prod aggregate functions design and implement replication and sharding o performance tuning and indexing strategies
- MMS monitoring, alert, backup and restore o Mongostat and Mongotop monitoring/analysis o Knowledge on sizing, tuning, autantication, authorization o Disaster recovery and rolling maintenance o backup and restore production support
- Responsible for supporting and maintaining transmission and processing of ratings information coming from the outside vendor to a Linux platform using Java and Python; file transmission to mainframe and into Teradata for the consumption of Statements
- Managed the Prelim and Montand tasks which involves cleanup of Teradata database spaces; execute and monitor sending Statements print files to Broadridge to generate printouts and pdf copies of clients Statement accounts; validation of each tasks on Linux and Teradata; and, ensuring smooth execution of the process by preventing delays.
- Responsible for supporting and maintaining flow of data from Master Security Data (VSAM) into Enterprise Database (DB2) involving daily batch and online process.
- Setup, support and maintain ETL/EDW from Enterprise Database (DB2) into Teradata through daily batch process.
- Setup, support and monitor acquisition feeds ETL/EDW from different sources/platforms and load to Statements Teradata tables
- Setup, support and maintain APIs that access the DB2 tables from several applications. Ensuring data integrity during the flow of data going to and out of EDB MSD.
- Participated in integration projects involving EDB-MSD through analysis, testing, deployment and data verification/reporting
- Responsible in all facets of Software Development Life Cycle (SDLC), including requirements gathering, establish technical specifications, set deadlines and milestones, designing, coding, testing, quality assurance and production deployment.
- Generate reports using SQL queries and SAS to investigate issues and provide analysis of test results
- Provided ad-hoc reports for the users and other development teams
Confidential, Jersey City, NJ
Senior Analyst/Developer
Responsibilities:
- Analyze business requirements, design specifications, coded and tested data results
- Responsible to the development of subsystems that will accept and process trades from domestic and international sources
- Responsible for data analysis and reporting using SQL queries and BASE SAS
- Supported the batch and online Government Securities system Online system includes CICS screens and background transactions that process trades transmitted via MQ.
- Analyzed, documented and resolved outstanding issues including bug fixes.
- Executed unit and system testing for batch and online modifications; validated and documented the results.
- Migrated changes from test to production with Quality Assurance team.
- Authored a generic process to send an email through Microsoft Outlook containing files in Excel format extracted from mainframe flat files.
- Developed subsystems that will accept and process trade feeds from other firms.
- Provided ad hoc reports for operations staff using SQL queries and BASE SAS.
- Devised test cases with business unit to test system modifications.