Professional Summary:

• Over 8 years of strong IT experience as a Data Base Administrator/MS SQL Server Developer in designing, developing, implementing and managing administration of database systems using M S-SQL Server for both OLTP Data Warehousing Systems applications in various IT Industry diversities like Insurance, Healthcare, and Banking sector.
• Expertise in Administration, Database Design, Performance Analysis and Production Support for Large VLDB and Complex Databases.
• Expertise in planning and implementing MS SQL Server Security and Database Permissions.
• Experience in Logical and Physical Database design development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Experience in using tools like MS SQL Profiler, Index Tuning Wizard, and Window's performance for monitoring and tuning SQL Server performance.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Involved in Migrating the SQL Server 2008 to SQL Server 2012 Side by Side .
• Experienced in Replication Snapshot and Transactional and extensive knowledge in Merge Replication.
• Hands on experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS Packages.
• Experienced with monitoring, troubleshooting related issues.
• Created and maintained SQL queries and stored procedures as needed.
• Ran diagnostics as required looking for poor performing queries, blocked processes or hung jobs.
• Implemented and maintained a backup and disaster recovery plans.
• Provided consultation on migration strategy, design, and decisions.
• Repaired and rebuilt Peer-to-Peer replication.
• Assisted the Manager and other team members with the development and coordination of the test strategy, test plans, scenarios and scripts.
• Played distinctive role in conducting and reporting results of application and performance testing provide quality assurance review of all application and system testing.
• Strong Knowledge in Creating, Configuring and Fine-tuning MS SQL Server Integration Services SSIS .
• Good experience in implementing Key Performance Indicator KPI Objects in SSAS and create calculate member in MOLAP cube in SSAS.
• Excellent team worker, self-motivated, and ability to work on multiple projects.
• Expertise in Troubleshooting Software and Hardware issues.
• Excellent communication, analytical, and problem solving skills.
• Excellent database programming skills using T-SQL.
• Timely submission of all administrative requirements and ability to effectively work on a team or independently.
• Good Knowledge in designing Database Models using UML, MS Visio and Erwin.
• Ability and willingness to learn new technology and deliver results in a timely manner.
• Maintained positive communications and working relationships at all business levels.

Tools and Technologies:

MS SQL Server 2012/2008/2005/2000, SQL Server Integration Services SSIS , SQL Server DTS, Data Stage, SQL Server Reporting Services SSRS , SQL Server Analysis Services SSAS , Rational Rose, Oracle 9i, TOAD 6.0, VB6, Microsoft Products MS Word, MS Excel, Share Point 2010/2007

Professional Experience:

Confidential

MS SQL Database Administrator Oct 2013 Present

Capital Novus is a global firm with comprehensive Knowledge Management and Litigation Support Consulting services, Capital Novus offers litigation risk management to Law Firms, Corporations, and Government clientele. The aim of the project was to design physical and logical models and to transfer data from different sources like text files, flat files, Oracle, excel and access to MS SQL server 2008/2012 and managing SQL database as whole entity.

Responsibilities:

• Performed business analysis, technical analysis, systems design, application software programming.
• Responsible for provide 24 X 7 critical production support to all 45 Production, development and clustered servers.
• Maintained 85 mission critical applications.
• Supported over 100 SQL 2005/2008/2012 databases in 5 node clustering environment A/P A/A including database mirroring on critical databases and databases 400 Gig in size
• Successfully Upgraded SQL 2000 to SQL 2008 and SQL 2008 to SQL 2012
• Designed, implemented, configured SQL 2008 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 2012 in clustered configuration. Planned, configured, tested and implemented failover cluster on Windows Applications.
• 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 2005 2008.
• Tested and applied latest service packs and cumulative Hotfix for SQL 2000/2005/2008.
• Installed and configured SQL 2005 Report and Analysis Services.
• Created DDL triggers for auditing any DDL change in SQL 2012
• 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 and 2012. Determined the SQL 2012 installation options. Tested the Installation of SQL 2008Server.
• 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

MS SQL DBA

Solix provides expert business process outsourcing services - the right people, processes, and technology and compliance programs - to help customers make fast, accurate eligibility decisions, enhance program integrity and efficiency and improve customer communications. My responsibility was to manage various phases of development of transactional and data warehouse system projects from definition and design through implementation, debugging, testing and deployment, ensuring application schemas and development are optimal and consistent across the solution using SQL programming language.

Responsibilities:

• Created and executed SQL statements in both SQL production and development environments.
• Provided 24 X 7 critical Support over 50 SQL 2008 servers and over 200 databases in clustering environment, associated with high volume websites with database size 500 Gig in size.
• Implement and maintain database security, replication, SQL Clustering, DTS, Log shipping, SQL Mail.
• Extensively involved with Backups and Recovery, Log Shipping and Replication
• Import and export data
• Promote/migrate SQL-Server objects from development to QA and QA to production instances
• Provide support to application developers in designing and implementing physical database structures.
• Implemented data models, database designs, data access
• Implemented security, generate and review report periodically and enforce security mechanism
• Maintain database integrity of all vendor and in house databases.
• Resolve and troubleshoot database issues, oversee and perform upgrades, conversions and deployments.
• Performance tuning - Monitor efficient use of memory and CPU resources.
• Proactively monitored the production database s and optimize stored procedures for better performance. Resolve locking conflicts and resource utilization
• Identifying performance bottlenecks OS, Network, Database , tuning of Both SQL statements and tuning of the RDBMS software, and recommend optimal performance recommendations.
• Hardware requirements and storage capacity planning for Development, Testing, QA, Staging, and Production for scalable database growth and performance
• Administer, maintain, develop and recommend policies and procedures for ensuring the security and integrity of the company's databases and systems
• Participates in emergency recovery of databases as well as manages physical structures, space utilization and participates disaster recovery testing.
• Documented database processing procedures, operations run books and system documentation and training of data processing and user personnel on system usage.
• Manage and resolve trouble tickets Remedy for database-related issues submitted by customers.

Confidential

MS SQL DBA/BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
• Extensively worked on SQL Server Integration Services SSIS and SQL Server Reporting Services SSRS .
• Expert in Using DMVs, Performance dash board, Mirroring, database snapshots and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor DTA .
• Expert in implementing the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Implemented Data partitioning, Error Handling through TRY-CATCH-THROW statement, Common Table Expression CTE .
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters HP servers in enterprise Data Centers .

Confidential

MS SQL DBA/BI Developer

Responsibilities:

• Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect used Kimball's approach on the development of logical data models.
• Database Administrator, Database Programming.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Deploying new code base release to UAT and Production Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Working with customers on Application rollouts and server migrations.
• Extensively worked on Enterprise Manager for managing the database.
• Troubleshoot performance problems and fine-tuning of databases.
• Involved in Index Analysis and Performance Tuning.
• Worked with different upstream team for downloading ETL MART data.
• Converting DTS packages into SQL Server 2005 Integration Services.
• Migrating SQL Server 2000 data bases into SQL Server 2005.
• Recovering the databases from backup in disasters.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Confidential

MS SQL DBA/BI Developer

Responsibilities:

• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables calculations from different databases.
• Installing SQL Server with minimum access privileges service account to improve security and to attain high ratings in SOC audits.
• Installed, configured SQL Server 2005 Clustering on Microsoft Clustering services MSCS from Hardware inventory to test environment.
• Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005.
• Having experience on SAN and RAID levels and building SQL Cluster servers on SAN Environments.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and implemented comprehensive Backup plan using SQL Lite Speed.
• Resolved and tweaked memory pressures caused during product release.
• Worked with customers on Application rollouts and server migrations.
• Troubleshoot performance problems and fine-tuning of databases.
• Expertise in designing databases and capacity planning.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data ETL to Data ware house by SQL Server 2005 Integration Services.
• Rebuilding the indexes at regular intervals for better performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Designed and created databases, tables, views, store procedures and triggers.

Confidential

MS SQL DBA/BI Developer

Responsibilities:

• Involved in Planning, Defining and Designing database based on business requirements and provided documentation.
• Monitoring the server for High availability of the servers.
• Solving the request raised by user support.
• Participate in implementation of new releases into production.
• Facilitates application deployment and joint effort deployments.
• Meet the SLA Service Level Agreement established.
• Day-to-day administration of live SQL Servers.
• Designed and implemented Security policy for SQL Servers.
• Used Stored Procedures, DTS packages, BCP for updating Servers.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
• Automated messaging services on server failures, for task completion and success.
• Execute procedures to accomplish short-term business goals.
• Deploying Administration tools like SQL DB Access, Performance Monitor and Backup Utility.
• Deploying monitoring tools like Site scope and spot light.
• Table partitioning to improve I/O access.
• Enforce Database Security by Managing user privileges and efficient resource management by assigning profiles to users.
• Using database level triggers code for database consistency, integrity and security.
• Tested and Implemented procedures to detect poor database performance, collecting required information, root cause analysis.