OBJECTIVE:

10 years of experience working in Multi - National companies has helped me develop strong analytical mind and problem solving skills in diverse business areas. Database Administrator, Analyst and Architect, with in-depth technical knowledge combined with strong management/supervisory skills. Hands on professional experience with ability to produce positive results in an efficient, quick and cost effective manner. Able to gather client requirements, design and implement work process solutions and database design, along with marketing data analysis, meeting extremely tight time and quality objectives. Skill set includes defining, developing, and modifying database systems, building the logical design model of a database, administering databases, meeting schedules and budgets, working with developers in performance tuning design and functioning as a change agent.

PROFESSIONAL SUMMARY:

• Hands on 10years’ experience in database administration/ Project Management and MIS in industries like health care, Leading Commercial Bank & Leading US based IT company.
• Experience in data analysis and database design for decision support systems.
• Large Scale data warehousing, profound knowledge of ETL, query tuning and database performance optimization using Microsoft SQL Server 2005/ 2008/2012/2014 , Analysis Services and Reporting Services.
• Knowledge in designing and developing OLAP cubes.
• Basic Knowledge of Big Data especially MongoDB
• Hands On Experience in MySQL Database
• Expertise in data migration among various cross platform.
• Expertise in DB Architecture for large scale enterprise solutions like Ecommerce, Stock exchange, Derivative market etc.
• Hands on experience on Cloud based solutions like Azure etc.
• Hands on experience with process management & software development lifecycle.
• Extensive experience in agile methodologies (scrum, Test driven development).
• Developed MIS for leading commercial bank during tenure for robust decision making from higher management. This MIS consists of more than 150 mission critical reports.
• Key role is for Query Optimization. I have optimized major long time taking SPs and scripts. Reduced the timing from Days to hours, hour to minutes and minutes to seconds.
• Handle Client’s production database having size ranging from GB to Several Terabytes.
• Enhanced reporting with OLAP cube & introduction of SSRS.
• Onsite support for various clients in Europe by implementing new changes, provide training and improving application performance by implementing database partition.
• Onsite visit to Netherland for Database Administration, implementation of OLAP reporting, Archival setup & Support.
• Setup DR using High Availability feature of SQL server for 2 UK based clients. Implemented other types of DR tools like Cluster, Mirror, Log shipping etc for other clients.
• Setup Partitioning & Sliding for enhanced performance and archival.
• Implemented SSIS, SSAS, SSRS, cube processing along with few reports in crystal report.
• Integration of application with various 3rd party channels like Tibco, pratos etc.
• Built up a data warehouse along with an intermediate log processing database.
• Got into production the replication system for processing web server logs and aggregating the data into a warehouse.
• Set-up a complete backup and recovery system
• Strive for continued excellence.
• Strong communication skills.

TECHNICAL SKILLS:

Databases: Oracle, SQL Server, Access (Expert)

Operating Systems: Windows NT and UNIX Solaris & LINUX (Expert)

Software: Oracle RDBMS,SQL Server, SQL*Plus, Oracle Designer, Microsoft Office, Lotus Notes, Various CAD software, Microsoft Project, Power Designer (expert), Microsoft Share point

Languages: SQL, PL/SQL, PHP- Code igniter, C, HTML, VB, Vb. Netetc (Expert)

Other: Oracle Database Administration, SQL Server Database Administration, Database Design, Apache web server, database performance tuning, database backup and recovery, data cleansing, data bulk loading, MIS, specification writing, customer interface, UML Analysis and design Summary of Technical Skills

KEY SKILLS & COMPETENCIES:

• Good understanding of software development processes and tools.
• Formal project management training.
• Knowledge of Agile and CMMI methodology.
• Taking ownership of assigned projects.
• Following through on projects with minimal oversight.
• Ability to drive influence team members through positive interaction.
• Resolute commitment to achieving goals and deadlines.

PROFESSIONAL EXPERIENCES:

Confidential, Washington, DC

Sr.SQL Server DBA

Responsibilities:

• Responsible for provide 24 X 7 critical production support to all 100 Production, development and clustered servers.
• Maintained 85 mission critical applications.
• Supported over 100 SQL 2000/ 2005/ 2008/2012/2014 databases in 5 node clustering environment (A/P A/A) including database mirroring on critical databases and databases 400+ Gig in size
• Designed, implemented, configured SQL 2008/2012/2014 DEV/QA environment on 2 node A/P cluster environment.
• Setup and configured Database mirroring in High Performance, High availability mode as standard DR strategy.
• Created snapshot of mirror database for reporting
• Configured and maintain transactional, merge replications.
• Designed and deployed SSIS packages in production environment to implement business logics.
• Create, deploy, configure and monitor complex ETL/SSIS packages
• Installed SQL Server 2008/2012/2014 in clustered configuration. Planned, configured, tested and implemented failover cluster on Windows 2007.
• Configured SSIS services, Database Mail, NETIQ Monitoring and Alerts on cluster.
• Upgraded databases and database objects, including logins, stored procedures, and jobs from MSSQL 2008 to MSSQL 2012.
• Automated daily database refreshes from production to staging and on-demand refreshes from production to test environments, involving SQL versions 2008, 2012& 2014.
• Tested and applied latest service packs and cumulative Hotfix for SQL 2008/2012/2014.
• Installed and configured SQL 2014 Report and Analysis Services.
• Created DDL triggers for auditing any DDL change in SQL 2005
• Implemented data partitioning to improve the performance of large table, reduces contention and increases availability of data
• Installed, configured and maintained Log shipping to create Standby Server.
• Created maintenance plan for database consistency and optimization.
• Document server and database policies and procedures.
• Involved in Change Management, Problem management activities using Service Now tool before implementing database changes in production and development activities.
• Created the backup and restore strategy for production, development and test environments.
• Involved in Disaster recovery and created the documentation.
• Involved in performance tuning using Performance Monitor, SQL Profiler, SQL Query Analyzer and Index tuning wizards.
• Created custom Performance Analysis reports in SQL 2005 for future hardware and software load/analysis.
• Determined hardware and software requirements for SQL Server version 2008, 2012 & 2014. Determined the SQL 2014 installation options. Tested the Installation of SQL 2014 Server.
• Managed databases on multiple disks using Disk Mirroring and RAID technology.
• Manage and resolve trouble tickets (HP service manager SM7) for database-related issues submitted by customers.

Confidential, Marion, IN

Sr. SQL Server DBA

Responsibilities:

• Managed security on Production and Development environments.
• Monitored the complete environment for resource utilizations and to avoid any bottlenecks.
• Creating and maintaining various databases on Production and development environments using SQL Server 2014/2012/2008/ 2005/2000.
• Created jobs to import/ export data obtained from various States to update the GIS servers.
• Installed and configured SQL Server Reporting Services.
• Installed necessary Service Packs for SQL server 2005.
• Installed SQL server 2005, 2008 and 2012 on a test environment to be the future production environment.
• Upgraded legacy 2000 databases to SQL server 2005/2008.
• Involved in Database Backup and recovery.
• Implemented high availability on the various servers using replication/mirroring.
• Tuned databases for better performance.
• Created and maintained various logins and managed security based on the required access.
• Implemented and tested the point in time recovery of the production databases.
• Involved in migrating share point from one server to the other.
• Created various jobs to monitor resources on various servers and to mail the necessary information when threshold was reached.
• Design/ developing SSIS (ETL) MDX developing components.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Loaded the data into another data sources (Oracle, SQL Server) using SSIS.
• Created various SSIS packages based upon the requirement.
• Created various reports using SSRS.
• Created the logical and physical data modeling using Erwin tool.
• Expanded Physical Data Model (PDM) for the OLTP application using ERwin.
• Analyzing the Performance of a Cube by partitioning it and creating Perspective Cubes.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Data migration using DTS services across different databases like Oracle, MS access & flat files.
• Contacted various users in gathering the requirements and documented the necessary changes.
• Analyzed various backup compression tools available and made the recommendations.
• Created necessary templates for various requirements gathering and documentation.

Sr. Database Admin/ Project Lead

Confidential

Responsibilities:

• Smartshopy - SaaS Based Ecommerce Platform
• Portfolio Management - Stock exchange’s portfolio management and Broker back office system.
• Confidential - Enterprise level entire solution for Ministry of Foreign Employment Nepal.
• SageCloud - SaaS Based centralized system to host all of company products in cloud. mRewards - Mobile based push Advertisement system. Etc
• Confidential - A centralized data ware house project which is used for importing large scale data from several ecommerce vendors like eBay, Amazon etc. Process the data and provide analytical reports. Tools used are SSIS, OLAP & SSRS.
• Worked as key role for performance monitoring and Tuning for all major running projects.
• Used various tools & techniques like Complex query optimization, Indexing, Implementation of Partition & Archival etc.
• Optimized various large user based applications/ portals having concurrent million users where performance was key bottleneck.
• One of the Milestone project where client was initially forced to add 3 IIS heavy servers as load balancer to handle millions of concurrent user. Key issue was in DB area which worked fine with single IIS server after DB optimization.
• Setup SQL Server High Availability with WCF in a mission critical production system for 25 clients.
• Implemented self-developed robust backup plan for all running projects which supports all types of backup types like FULL, Differential & Log backups, auto alert system for failed backups, transfer of backup files to shared storage, backup file encryption.
• Worked extensively for data migration for several clients like Confidential, Nepal stock exchange, Broker back office system (BBOS) etc. Developed various ETL tools like SSIS, developed custom made complex scripts to migrate high volume complex data from MySQL & Oracle to SQL server.
• Developed system approach like using code versioning system for Database objects for patch release in production environment and code security/ versioning.
• Study As-Is Process Identify Gaps and Improvement Opportunities Derive Redesign Concepts Define Metrics & Measures Establish & Deploy Implementation Plan Implement Change Management Monitor and Review Implementation
• Conceptualize New Software Products Prepare Project & Release Plan Document and Share Product Features Conceptualize and Design Mockups / Wireframes Manage Product Development
• Last but not least, my key role at Braindigit is knowledge transfer. Conducted several types of DB training to all level of staff for coding standards, best practices, case studies & introduction of new technology.

Sr.Software Developer/DBA

Confidential

Responsibilities:

• Worked extensively for enhancement of existing ETRM software with new features like introduction of hourly position calculation, MTM, profit & loss, SSIS etc.
• Key role is for Query Optimization. I have optimized major long time taking SPs and scripts. Reduced the timing from hour to minutes and minutes to seconds.
• Primary task is to develop, optimize mission critical MIS reports using PHP, &SSRS.
• Reduced Production DB size from 1100GB to 500GB using compression technique without any performance degrade and deletion of record.
• Developed various new reports like forward actual, hedge reports etc.
• Handle Client database having size of 1.5 TB.
• Enhanced reporting with OLAP cube & introduction of SSRS.
• Onsite support for various clients in Europe by implementing new changes, provide training and improving application performance by implementing database partition.
• Handle day to day Database Administration along with performance enhancement,.
• Onsite visit to Netherland for Database Administration, implementation of OLAP reporting & Support.
• Resolve the Existing Performance bottleneck using various optimization tools& techniques.
• Setup DR using High Availability feature of SQL server for 2 UK based clients.
• Setup Partitioning & Sliding for enhanced performance and archival.
• Implemented SSIS, SSAS, SSRS, cube processing along with few reports in crystal report.
• Integration of application with various 3rd party channels like Tibco, pratos etc.
• Contract positions as required by various companies.
• Built up a data warehouse along with an intermediate log processing database.
• Got into production the replication system for processing web server logs and aggregating the data into a warehouse.
• Set-up a complete backup and recovery system
• Skills used- Oracle/ SQL Server administration and installation, performance tuning, Backup and recovery, SQL, PL/SQL, Oracle Designer, Technical documentation

MIS Incharge / DBA

Confidential

Responsibilities:

• Developed Data warehouse system in form of Banking MIS for day to day reporting and BI using crystal report with Oracle as backend.
• Developed more than 150 reports using ad-hoc queries and dot net platform.
• Delivery of critical MIS report in automated email format on daily basis in first hour.
• Look after Day to Day Database administration especially for backup & recovery and Performance Tuning for Core banking System. Bank is using Finnacle and Oracle 10g.
• Implemented Database clustering and DR.
• Completely responsible for a 7 x 24 Oracle database operation involving both Core banking, e-banking, market data collection and e-mail pushes.
• Setup and tested a 7 x 24 database fail over system and data recovery.
• Developed the concepts for the metadata portion of the data transformation processes including a database driven job control section.
• Designed and implemented a statistical gathering, reporting and data aging system for profile repositories.