SUMMARY:

• Over 8+ Years of IT experience as SQL Server Developer with RDBMS and NoSQL experience PostgreSQL Database, MongoDB; Couchbase, Oracle and Hadoop technologies on UNIX, Linux and Windows platforms.
• High level knowledge of PostgreSQL and MongoDB deployment topologies, including active/active data centers and disaster recovery.
• Data modeling for data from RDBMS to MongoDB for optimal reads and writes.
• Installation of Postgres on physical machines, Virtual machines, created a PostgreSQL Database on multiple operating systems.
• Extensive hands - on experience in Big Data projects with MongoDB, Couchbase and related technologies
• Able to perform I/O operations (CRUD) on Documents using Couchbase and MongoDB Java API and implemented Map/Reduce Functions.
• Analyzed the performance of MongoDB and Couchbase Server with heavy I/O operations, Observed changes using different Graphs and Statistics in terms of RAM and Disk Space. Created a Simple REST application using Drop Wizard, which pulls the data from Couchbase in JSON format. .
• Experience in bringing up and maintaining couchbase and Postgres cluster, capacity planning, performance tuning and monitoring.
• Application performance optimization for Postgres database cluster.
• Installed Cassandra 2.x in Production, Pre-prod environments as per best practices and upgraded Cassandra databases from 1.x to 2.x
• Recommends solutions by defining the database physical structure and functional capabilities, database security, data back-up, and recovery specifications.
• Advanced experience using SQL Server Management Studio 2005 and Visual Studio 2005.
• Experience in Installing and Upgrading MS SQL Server suite of products in Windows environment from 2005 to 2008 R2 and from 2008 R2 to 2012.
• Excellent skills in design and development of ETL packages using SSIS for integrating data from heterogeneous sources (Excel, CSV, Oracle, Flat File and Text File) using multiple transformations available in SSIS toolbox such as Data Conversion, Conditional Split, Bulk Insert, Merge, Lookup and Union all.
• Hands on experience working with Data Marts, Data Warehouses building Facts, Star and Snow Flake dimensional models.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server Reports in SSRS 2005/ 2008/2008 R2 using data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
• Expertise in report development using SSRS, BO Reporting tools like Universe, Web Intelligence and Crystal Reports.
• Well versed in implementing business logic using SQL Queries, Stored Procedures, Functions, Views, Data base tuning and performance techniques.
• Expertise in Database Management Systems including but not limited to Microsoft SQL Server 2012/2008/2005, Teradata, DB2 and Oracle 11g/10g/9i.
• In depth knowledge of designing Entity Relationship and Data Flow Diagram for Business processes.
• Outstanding communication and interpersonal skills, ability to learn quickly, hardworking, good analytical reasoning and high compliance to new technologies and tools.
• Good understanding and hands-on experience on XML, XSL (XSLT, XPath, XSL-FO).
• Experience with defect tracking and analysis using different defect tracking tools such as TFS (Team Foundation Server)
• Experience Installing and Configuring PostgreSQL from source or packages on Linux machines.
• Experience monitoring PostgreSQL database using the standard monitoring tools like PEM etc.
• Involved in Configuration and Maintained Storage devices like NAS, SAN devices, replication.
• Expertise in Oracle Enterprise Manager (OEM), Grid Control and Cloud Control.
• Identifies database requirements by interviewing customers; analyzing department applications, programming, and operations; evaluating existing systems and designing proposed systems.
• Excellent team player and works independently, actively participates in team meetings and maintains good relations with everyone on the team and other teams.
• Provided 24x7 production support for multiple databases environments across different clients.

TECHNICAL SKILLS:

Operating Systems: Linux (RHEL, Ubuntu etc), Unix (AIX, HP-UX etc), Windows(2000, xp, vist, 7, 2005, 2008 server etc), Mac 10.x etc.

Relational Databases: PostgreSQL 9.x; MySQL 5.x etc.

NoSQL Databases: MongoDB 3.x, 2.x, Couchbase 3.x, 2.x, etc..

Hadoop Ecosystem: Cloudera Hadoop 5.x, Cloudera Manager, HDFS, spark, Hue, MapReduce, flume, sqoop, Hive, impala, zookeeper etc.

Programming/Scripting Languages: Sql, PL/Sql, Linux shell Scripting, JavaScript and Python etc.

Database Utilities: pgBouncer, vacuum, postmaster, pgpool, Pgadmin 4, Postgres Enterprise Manager, MySQL Workbench MongoDB MMS, OpsManager, Cloudmanager, mongodump, mongorestore, RoboMongo, UMongo, mongohub etc. Datastax OpsCenter, nodetool, sstableloader, NoSQL Manager etc. Couchbase-cli, cbbackup, cbrestore, workbench developer etc. Elastic HQ, kpof, etc, SQL*PLUS, ErStudio, SQL Developer, plsql Developer, toad, My ora 4.0, TOAD, Commvault, winscp, Crontab, PUTTY, Cygwin - X.

Cloud and Virtualization: AWS, Azure, Google compute Engine, Docker containers, VMware, Virtual box etc.

Monitoring/DevOps tools: Nagios, Ganglia, Munin, puppet, chef etc

Hardware: IBM 3090, HP Blade Servers, CB500; Ciscso Servers; Oracle Exadata Machines; Commodity Hardware etc

PROFESSIONAL EXPERIENCE:

Confidential, NJ

Sr. Database Administrator

Responsibilities:

• Created and managed multiple PostgreSQL Database clusters
• Recommending optimal schema designs for better performance and scalability; enforcing Enterprise security policies and procedures on databases
• Collaborated with ops, engineering and development teams to determine impact of database changes on other systems
• Responding to production issues, making recommendations, taking actions, and performing root cause analysis.
• Planning, installation, configuration, optimization, maintenance and monitoring of different NoSQL database instances including MongoDB, Couchbase Cassandra etc
• Integrating MongoDB with Elastic Search, solr, Hadoop and Spark using connectors.
• Evaluated the features of postgresSQL such as JSON support, point-in-time recovery, database encryption, HA options etc.
• Implemented mixture of on-prem and cloud based solutions to minimize single point of failures at database layer.
• Tuning SQL to identify bad or slow SQL; find possible performance issues; reduce total execution time etc
• Reviewing the SQL Query execution plan and Optimize statistics and behavior.
• Used PEM's Postgres log analysis expert wizard to analyze log messages
• Configure Database; OS & Hardware setting inkling memory WAL Checkpoints; filesystem options etc.
• Optimize O.S settings such as memory; CPU DISK (I/O) for PostgreSQL database implementations.
• Implemented pgbench for running benchmark tests on PostgerSQL
• Install and Set-up Replication Server and Post Installation Configuration
• Research, evaluate and recommend NoSQL solutions and suggest best use case scenarios.
• Implemented Backup's using Postgres Enterprise Manager's (PEM) and Continuous Archiving
• Implemented database security using host based access controls, SSL, Passwords & data encryptions.
• Provide 24/7 on-call support on rotational basis

Environment: TSQL, MS SQL Server 2008 R2, MS Visual Studio, SQL Server Integration Services (SSIS), Management Studio, SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), SAP, OLAP, XLST, XPATH, C#, Cognos

Confidential, Lancaster, PA

Sr. Database Administrator

Responsibilities:

• Installation of MongoDB Database on Windows and Linux Machines, manage and maintain MongoDB servers across multiple environments.
• Supported multiple applications and support teams with numerous on-going projects.
• Provided services to application development teams, including database design, database generation, coding, and performance related issues.
• Setting up pgpool for connection pooling; Replication; Load balancing and automatic failover
• Implemented PgBouncer to reduce connection impacts on the PostgreSQL Server
• Managing numerous databases in production, QA, and dev environments. Including installation, configuration, backup, recovery, upgrades, schema changes, etc.
• Implemented data replication in PostgreSQL by log-shipping standby servers upgrading PostgreSQL to the latest versions using pg upgrade
• Advised Software Development teams on Database performance improvement changes
• Setting-up Multi-Master Replication and secondary master replication in PostgreSQL.
• Restoring SQL Dumps and cluster dump
• Understand application requirements and come up with a setup that is fault tolerant and scalable across multiple data centers.

Environment: MS SQL Server 2012,2008R2,VS2010,Business Intelligence Development Studio (BIDS),T-SQL, XML, Performance Point Server 2007, SSIS, SSRS, SSAS,OLAP, OLTP, Windows 7, Microsoft Excel.

Confidential, Cincinati

Database Administrator

Responsibilities:

• Worked on complete Project Life Cycle that includes requirement gathering, development, testing and production support for the finance (Revenue and billing applications) and order management departments.
• Developed Oracle PL/SQL stored procedures, triggers, functions, packages, materialized views, SQL scripts and database objects to facilitate the Extraction-Transformation-Loading (ETL) process.
• Designed and build OLAP processes using PL/SQL packages and triggers
• Designed and Developed Logical and physical Data Model of Star Schema including Dimension and Fact tables
• Involved in analyzing and adding features like DBMS LOCKS, DBMS SHEDULER, DBMS JOBS and creating directory and Hierarchical queries and Indexes (Bitmap and B-tree).
• Used Bulk Collect feature and Dynamic Sql to improve performance.
• Created the Partitions and Sub-Partitions on the Oracle tables dynamically.
• Involved in extracting large volumes of data from different data sources, performing transformations and loading that data and provided interface between Oracle and Hyperion tools.
• Managed performance and tuning of SQL queries and fixed the slow running queries in production with utilities like Explain plan
• Troubleshooting and resolving issues in various aspects of the post production support
• Created dimension build and data load rule files for cubes.
• Used the VI editor to create korn shell scripts.
• Version control using PVCS, Managed delivery and deployment of the development objects to higher environments using deployment channel.

Environment: : Oracle 10g PL/SQL, SQL Developer, SQL Navigator, PL/SQL Developer, OBIEE, Toad, Shell Scripting, UNIX, VBA, Erwin, VI editor, Master Data Management (DRM/MDM), Interactive Reporting, PVCS.

Confidential

Database Administrator

Responsibilities:

• Installation of MongoDB Database on Windows and Linux Machines, manage and maintain MongoDB servers across multiple environments.
• Develop and document best practices for data migration; Design & implement High Availability and Scaling strategies.
• Admin MongoDB to achieve 100% monthly availability; solve production DB problems when needed.
• Extensively worked on Replication; configuration and re-configuration of replica sets in Single and Multiple Datacenters.
• Extensive worked on security, failover, recovery, backups and restoring from backups in MongoDB.
• Implemented Hadoop technologies such as MapReduce, HDFS, and Spark etc.
• Extensive worked on MongoDB scaling solutions - Range-based, Hash-Based and Tag-Aware shardings concepts.
• Solving production problems and participate in a 24x7 on-call rotation.
• Creating oracle 11g/ 12c databases on unix and windows operating systems including standalone and VM servers conforming to oracle's optimal flexible architecture (OFA) standards
• Support more than 30 Oracle 11g/12c rac/asm, database instances as in prod /qa/dev and provided 24x7 support for Production databases.
• Maintaining of rac and Managing RAC Environment efficiently.
• Implemented Oracle Data Guard for high availability in RAC environment.
• Implemented Datapump and rman to migrate data from prod to other environments.
• Worked with the System Administrators in planning storage requirements for all environments related to the project, manage and monitor storage usage.

Environment: : SQL Server 2008R2, SQL Server Integration Services, SQL Server Reporting Services, Business Intelligence Development Studio-SQL, DTS, SQL Profiler, OLAP, OLTP, MS-Excel.

Confidential

Database Administrator

Responsibilities:

• Involved in installation and configuration of SQL Server 20015.
• Creating SQL Server Queries, functions, Stored Procedures in SQL Server.
• Created various database objects such as tables, indexes and viewsbased on therequirements.
• Optimized SQL queries for efficiency and the front-end developer with their queries and procedures.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery Procedures and Contingency plans. Testing and implementing these procedures.
• Created views to reduce apparent database complexity for end users and to prevent sensitive columns from being selected.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Created indexes to speed the execution of data retrieval queried and stored procedures.
• Creating Staging Database and Import Tables in MS SQL Server.
• Created views to reduce apparent database complexity for end users and to prevent Work with business stakeholders, application developers, and production teams and across Functional units to identify business needs and discuss solution options.

Environment: SQL Server 2005, Visual Studio 2005, T-SQL, SQL Query Analyzer, MS-Excel.