OBJECTIVE:

To obtain a leadership database administration or development leadership position supporting database solutions, architecting innovative solution, troubleshooting and supporting mission critical production environments.

SUMMARY:

• I have more than twenty years of experience as a Manager, DBA, and application software developer.
• I have worked at various levels starting as a programmer to managing a team of DBAs. Last twelve years I have been mostly focused on SQL Server and all the aspects of SQL Server database and tools.
• I have worked with SQL Server 2014/ 2012/2008/2005/2000 starting with SQL Server 6.5.
• I have built and maintained ETL applications using SSIS, SSRS, SSMS, and other tools.
• I have extensive technical knowledge on MS - SQL Server Management, Disaster Recovery, Backup/recovery, High Availability, Mirroring, Log-Shipping, Always On, Service Broker and Data Replication, DTS/SSIS, Capacity Planning, Performance Tuning, SSRS and some SSAS.
• I also have expertise in other technologies that I have embarked on my past endeavors.
• Over ten years of proven leadership in database management group for a fortune 500 company, an aggressive financial enterprise, a technological solution provider in their vertical segment.
• Proven ability to build teams, setting objectives, standards, policy and procedure for the team.
• Proven ability mentoring, providing leadership, direction and solution.
• Proven ability to provide progress reports to management and day to day resource management.
• Proven ability to assist management with their budget planning and procurement needs.
• Thriving in high pressure and rapid growth environment.
• Extreme reliability, dedication, professionalism, humility and attention to detail.
• Rapid adaptability, eagerness to learn, adapting to ever changing goals and methods.
• Excellent resource management skills delivering projects on time and under budget.
• Inspiring, confident, loyal, invoke motivation and humble to management and subordinates.
• Provide thoughtful clear and concise written and verbal communication.
• Inclusive to all kinds of employee coming from various parts of the worlds.
• Ability to research existing process, methods and practices to improve and save expenses.
• Strong ability to multitask and deliver.
• Extensive experience in SQL Server 2014/2012/2008/2005/2000/7.0/6.5.
• Extensive experience in installing, configuring, managing, monitoring and troubleshooting database environments.
• Extensive experience in building applications using SQL Server SSIS, DTS, BCP, TSQL, Store Procedure, Triggers, UDFs, VB Script and VB/C Sharp .Net, VSS, TFS, SharePoint.
• Expertise in SQL Server Database server and TSQL tuning using technological knowledge of SQL Server internals and following SQL best practices.
• In depth knowledge and experience in SQL Server high availability solution like SQL Server Always On, SQL Server Database replication, SQL Server Mirroring, Log Shipping.
• Solid experience with SQL Server messaging technologies like Service Broker, Notification Service and MSMQ.
• Hands on experience in SQL Server clustering, building databases, backup/recovery, SQL Server maintenance, security management, SQL Profiler, SQL Tuning Advisor, SQL execution plan analysis, SQL jobs, mails, alerts, SQL reporting services.
• Extensive experience in migration of SQL Server from 7.0 to R, and .
• Managing about production database servers with database raging from 5GB to 20TB.
• Experience with SQL Server third party database tools like IDERA Diagnostic, IDERA Compliance, Red Gate SQL Compare, Red Gate Data Generator, RedGate Backup compression, SCOM etc.
• Solid hands on experience in Data Modeling. Used many data modeling tools like Visio, Erwin, ER Studio, Turbo Analyst etc.
• Solid knowledge of Data Warehousing concepts and components. Strong hands on experience in building and managing data warehousing solutions.
• Experience with installation, configuration, managing, monitoring, and troubleshooting other DBMS database like Oracle, Informix, Sybase and Unify. That involved knowledge of all the tools used in these DBMS technologies. Migration of data and databases between all these DBMS technologies.
• Acute understanding of Software Development Life Cycle.
• Architected and developed solution for countless applications ranging from small, mid size to large enterprise level applications.
• Developed applications for small shop to fortune 100 enterprises from few user base to hundred thousand user base.
• Extensive experience in all the phases of Software Development. Namely Requirement Analysis, Design, Development, Testing, Implementation and Production Support.
• Extensive experience in building ETL applications using SSIS, DTS, BCP, TSQL, Mercator, EDI, MQSeries, MSMQ.
• Extensive experience in building thick client applications using C, VC++ 4.0/6.0, VB 4.0/6.0, Oracle FORMS 3/4.5, PL SQL, Informix 4GL, Unify, C-Tree, D-Tree etc.
• Extensive experience building application and tools using 3GL like C, C++, VC++, MQSeries, MSMQ, XML, EDI.
• Extensive experiences writing application using UNIX internal, C, Shell Scripting, AWK etc.
• Extensive experiences writing client server applications for middle wares and device drives.
• Experience in writing application like windows services and web servers in Window and NT platforms.
• Experience in writing thin client applications using .Net framework, ASP, HTML, Java and VB scripts.
• Experience in writing reports using Report Writer 1.1/2.1 and Crystal Reports 7.0 etc.

TECHNICAL EXPERTISE:

DBMS: Microsoft SQL Server 6.5/7.0/2000/2005/2008/2008 R2/2012/2014, Data Warehouse, Informix Universal Server 9.3, Informix Online/SE 7.1/6.0/5.0/4.1/2.1 , Oracle 8i/7/6, Forms 3.0/4.5, Report Writer 1.1/2.1, Sybase MDI Client, Microsoft Access, Unify, Accell, Rpt, c-tree, d-tree, r-tree, Foxpro, Foxbase, Dbase.

Others: SQL Server SSIS/DTS Package, VB/Java Scripting, C, C++, Visual C++, Visual Basic .Net, CSharp, .Net, XML, Shell Scripts, Mercator, IBM MQSeries, EDA, EDI, Sybase Open Client for MDI Gateways, ER-Win, SFL libraries, Crystal Reports 7.0, Install Shield Professional 2000, Informatica, Microstrategy, Visio, Java, Html, IIS, Asp, Cobol, Awk, Pascal, Assembly, PVCS, SCCS, Exceed, Case Tools like Turbo Analyst, Easy Case, Synthesis, Microsoft products like Word, Excel, Access and others.

Operating Systems: Windows 3.1/95/98/ 2000/2003/2008/2012 , Sun OS, Solaris, IBM AIX, UNIX, Windows-NT, MS-DOS, X-Windows.

PROFESSIONAL EXPERIENCE:

Confidential

Contractor/DBA and Database Developer

Responsibilities:

• Do initial evaluation of existing 2008 development and production environment and recommend solution
• To suggest and implement industry standards and best practices at server level, database level and process level.
• To steam line their database development and deployment process.
• To clean up the environments.
• To setup appropriate environments following SDLC process. Introduce QA, breaking their existing DEV/QA environment and process.
• Implement all the recommendation after initial analysis.
• Do performance tuning analysis and recommend solution
• To evaluate the server capacity and needed upgrade.
• To recommend appropriate Primary Keys to all the tables.
• To evaluate indexes and recommend indexes and statistics.
• To tune queries.
• To create stored procedures and user defined functions.
• To replace inline SQL from the client applications and replace them with stored procedures and functions.
• To evaluate other performance parameter and recommend solution.
• Implement all the performance tuning recommendations.
• Evaluate and plan database migration from SQL Server 2008 to SQL Server 2014.
• To create migration plan.
• To test it in development.
• To recommend solution to the issues associated with the migration.
• To coordinate and implement the migration in QAL.
• To coordinate and implement the migration in PROD.
• Implement all the migration steps and plan following SDLC process.
• Provide post migration support and enhancements.
• Write queries, stored procedures and stored function requested by development team.
• Document all the work done and create user guide for the team to follow after my departure from the project.

Environment: SQL Server 2008/2014 (Enterprise Version/all versions) with Windows 2008/2012 Server and VMWare. SQL Server Clustering, XML, TSQL Server Profiler and Tracing, IBM CastIron etc.

Confidential

Sr. DBA Developer/DBA/Manager

Responsibilities:

• Installing and configuring the database software in active/active or active/passive multi server clustered and non clustered servers. Installing and uninstalling the clients for the database.
• Troubleshooting the installation and connection related problems.
• Create/Drop databases and its components. Estimate the disk space and others.
• Resource and capacity planning.
• Coordinate with the developers and the users for any database enhancements.
• Create maintenance jobs and schedule them.
• Building and supporting high availability solution using SQL Server Always On, Mirroring, Log Shipping and SQL Server Replication
• Building disaster recovery solutions
• Deploying and supporting messaging solution using Service Broker, Notification Service, and MSMQ.
• Schedule and monitor Daily/weekly/monthly backups.
• Writing scripts for the database maintenance, startup and shutdown.
• Monitor all the database status. Keeping all the database and server uptime to maximum.
• Tuning all database programming components like stored procedures, trigger, stored function and indexes.
• Tuning database server components.
• Performing QA on all the database components being released to production.
• Monitoring database resources using SQL Server profiler and tracing. Day to day monitoring of all databases supported in the production. Proactively solving the problem before the user group faces the problem and opens an issue ticket.
• Trouble shooting any problem forwarded from the technical support call center.
• Providing technical solution to any complex production problems.
• Providing technical and architectural solution to the developer problems and suggesting alternative solutions for performance.
• Trouble shooting the database problems.
• User creation and control access to the databases and its components.
• Architecting, building and supporting ETL solutions.
• Writing and deploying SSIS/DTS packages in production. Tuning the performance of these packages.
• Mentoring and assisting DBAs under me with their tasks and projects.

Environment: Numerous IBM, HP, Dell, Compaq High End Servers (x64, Itanium, 32bit) to host SQL Server 2012/2008/2005/2000 (Enterprise Version) with Windows 2000/2003/2008/2012 Server. SQL Server 2012 Always On, SQL Server Replications, SQL Server Clustering, SQL Server Mirroring, SQL Server Log Shipping, Service Broker, Notification Service, Integration Service, Reporting Service, MSMQ, SSIS/DTS package, XML, TSQL Server Profiler and Tracing, RedGate, IDERA, MOM, SCOM, DB tuning advisor, Stored Procedure, Stored Functions, VB Script, Jscript, C# .NET application, VSS, TFS, Source Offsite, Vision 2000, ERStudio, MS Access.

Confidential

Database Administrator/Senior Associate/Analyst

Responsibilities:

• Designed, developed, implemented and supported the data warehouse daily data uploads. Providing solution to any data related problem.
• Database design, data source, upload procedures and data maintenance for Data Warehouse.
• Design, develop, test and implement all the enhancements to the Data Warehouse systems and other applications.
• Coordinating with the business analyst for any business enhancements.
• Providing technical solution to any complex production problems.
• Providing technical and architectural solution to the application system enhancements.
• Trouble shooting any problem forwarded from the technical support call center.
• Day to day monitoring of all the applications supported in the production. Proactively solving the problem before the user group faces the problem and opens an issue ticket.
• For all the system developed by the third party, provide a technical and database support. Trouble shooting any database related problem. These solutions included the data modeling, database design and enhancements/changes to the current database components. Handling the database performance enhancement issues.
• Contacting and coordination with the application (tools) vendors for the technical support for their product.
• As a DBA perform following responsibilities:
• Installing and uninstalling the database software.
• Installing and uninstalling the clients for the database.
• Trouble shooting the installation and connection related problems.
• Create and drop databases and its components. Estimate the disk space and other resource requirements.
• Coordinate with the developers and the users for any database enhancements.
• Create maintenance jobs and schedule them. Schedule and monitor Daily/weekly/monthly backups.
• Writing scripts for the database maintenance, startup and shutdown.
• Performance tuning.
• Monitor all the database status. Keeping all the database and server uptime to maximum.
• Trouble shooting the database problems.
• User creation and control access to the databases and its components.
• Maintaining the licensing agreement on the database and other supporting software.