MIS 2000, Inc.

Description

PROFESSIONAL SUMMARY:

 

• Had 8 plus Years of Experience in SQL SERVER database administration and development for very large and complex databases in SQL server 2016, 2014, 2012, 2008, 2005 and 2000.
• Extensive experience in Installation, Configuration and Administration of SQL server in a Clustered and Stand-Alone
• Experience in In-Place and Side-by-Side migration of MS SQL server 2000/2005 to 2008/2008r2 and 2008r2 to 2012/2014/2016.
• In-depth knowledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views.
• Knowledge of storage capacity planning, experience in regular maintenance activities like performance tuning, query tuning, update statistics, log file monitoring, temp DB monitoring, handling blocking, deadlock resolutions, and fragmentation issues using DMV’s and DBCC
• Expertise in SQL server Backup/Restore, having knowledge in upgrading of SQL servers.
• Solid experience and outstanding knowledge on High availability & Disaster recovery techniques like Log Shipping, Mirroring (High safety and High performance), Replication (Snapshot & Transactional) and Clustering (Active-Passive and Active – Active).
• Implemented Always-on Availability Groups.
• Experience in creating and implementing maintenance plan with stored procedures, T-SQL Scripts to ensure smooth running of SQL server.
• Experience in automation of administrative tasks like creating Jobs, Alerts using SQL server Agent.
• Extensive experience in configuring Registered Servers, Linked Servers, and Multi Server Administration.
• Auditing of database for users transaction, logins, database action and fixing orphan users.
• Experience in configuring DB Mail and Migration of Data from Excel, Flat file, Oracle to MS SQL server by using SSIS, BCP and DTS
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for rectifying the errors.
• Experience in creating SQL Server Reports usingSSRS 2005 and 2008.
• Strong interpersonal skills, with the ability to easily and effectively interact with technical, non-technical, and business staff at all levels.
• Proficient in third party tools like Litespeed, Idera, SQL Compare, Redgate, Net backup and SQL Sentry.
• Experience working with change control process/change management which involves development, testing and production.
• Thorough knowledge on SAN environments, RAID levels, VMware
• Hands on Experience in databases such as MYSQL, Microsoft SQL Server, MongoDB (No Sql).
• Acquainted with all the phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation and Agile methodologies including SCRUM and Sprints.
• Strong experience in mentoring junior team members, documentation.
• Extensively worked in 24×7 Production environment.

 

 

TECHNICAL SKILLS:

Databases:	MS SQL Server 2016, 2014, 2012, 2008, MS SQL Server 2005,2000
Programming:	C, C++, T-SQL, POWERSHELL
Operating System:	Windows 2008/2003 & Windows 10
Data base Tools:	SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server, Management Studio.
Applications:	Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.
Third party tools:	Litespeed, Idera, SQL Compare, Redgate, Net backup and SQL Sentry.

 

WORK EXPERIENCE:

NCR CORP, DULUTH, GA

Role: SQL Server DBA                                                        2015, SEPT-TILL  DATE

 

Responsibilities:

• Installation and configuration of SQL server 2014, 2012 and SQL server 2008R2 applying service packs in both Cluster and stand-alone
• Migrated SQL server from 2008R2 to SQL server 2012/2014 databases.
• Tuned queries which are running slow using different ways such as evaluating joins, indexes, updating Statistics and code modifications.
• Involved in daily routine activities like backup, restore, refreshing databases as per requirements.
• Configured log shipping with monitoring instance as a disaster recovery
• Implemented Always-on-Availability Group as part of High Availability solution on SQL server 2014 and 2012.
• Created database mail and operators.
• Involved in index maintenance plans like rebuild & reorganizing the indexes according to index fragmentation.
• Implementation of SQL server logins, Roles and Authentication modes as a part of security policies.
• Created jobs and alerts using SQL server agent, monitoring and troubleshooting the jobs.
• Created Linked Servers between 2005 and 2008 R2 servers.
• Provided RAID level suggestion for data files, log files and tempdb drives.
• Implemented data partitioning for large tables to increase the performance.
• Configured Replication (transactional replication).
• Resolved blocking, deadlocks, client/server connectivity, database consistency checks using DBCC
• For performance analysis used the tools like SQL server profiler, Index Tuning Wizard and database Tuning Advisor.
• Developed SSIS packages to transfer the data between production and development environments.
• Developed SSRS reports on DBA metrics data.
• Developed web applications and help refractor legacy applications.
• As a DBA predicted how test applications will perform once they are moved to production.
• Performed New development and maintenance work can be in the test environment and operational applications in the production environment.
• Designed and Developed packages for Archiving FACETScustom data base using SSIS , C#.NET and SQL  Server 2012.
• Extensive knowledge in Mongo DBconcepts and good knowledge in Administration.
• Implementation of the Business logic layer for Mongo DB Services.
• Designed and developed a backend for client’s website using C# .NET  and SQL Server.
• 24X7 on call support.

ENVIRONMENT: Microsoft SQL Server 2000, 2005, 2008 R2, 2012 and 2014, Windows 2003/2008R2/2012, SSRS, SSIS, SSAS, PL/SQL.

 

WISCONSIN   DEPARTMENT OF WORKFORCE DEVELOPMENT MADISON, WI

Role: SQL Server DBA                                                        2014, APRIL-2015, JULY

 

Responsibilities:

• Experience with Multi- Servers and Multi-Terabyte Databases design for Very Large Databases.
• Performed installationsas per client requirements.
• Performed migration from SQL server 2008 to SQL server
• SQL Server 2012 Always-On experience with high availability.
• Designed, configured and created databases, tables, indexes, constraints, writing stored procedures, triggers, views, functions and cursors.
• Automated regular Database Maintenance tasks by creating Jobs and Alerts using the SQL server agent and Database mail.
• Performed backup using backup compression and data compression.
• Troubleshoot for SQL Server performance related Issues in the servers using DBCC commands, DMVs and Performance Counters.
• Configured and managed database maintenance plans for update statistics, database integrity check and backup operations.
• Configured Database Mirroring with high performance and high safety mode.
• Implemented Snapshot and Transactional
• Migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, Attach/Detach and Data Migration tools.
• On the new SQL Servers configured required users and fixed orphan users with rev login script.
• Extensively worked on Transparent Data Encryption (TDE).
• Truncated/shrink transaction logs, checked data allocation errors and any data inconsistencies and updating database statistics.
• Responsible for setting up Team foundation server, creating projects and adding members. Configured and deployed infrastructure.
• Responsible for managing share point sites.
• Responsible for managing, compiling and deploying code on TFS.
• Rendered reports in CSV, PDF, XML and Delivered reports by file share and E-mail according to schedule.
• Installed, Configured SSRS and Created, Deployed SSRS Packages.
• Troubleshot performance issue as and when they arose using ticketing system using BMC Remedy application for creating and tracking ticket and on floor Tech Support team for resolution.
• Develop documentation that sufficiently describes technical deliverable as required for internal controls so that the maintenance responsibility can be passed on to production support team.

ENVIRONMENT: SQL Server 2012, 2008 R2/2005/2000, Windows 2003/ 2008 Server, C#.net, VB and ASP.NET, Lite Speed, MS Visio, Microsoft SQL server Visual Studio 2005/2008.

 

 

PROGRSSIVE INSURANCE, MAYFIELD, OHIO

Role: SQL Server DBA                                                                    2012, JAN-2014, FEB

 

Responsibilities:

• Finding out any missing standards and Providing Best practices for maintaining SQL Servers efficiently. Successfully implemented several new standards for the Client, with tremendous proven improvement as part of SQL  Security Vulnerability Remediation.
• ProvidedDBA support for multiple applications in development, test, and production environments.
• Performed installation of SQL Enterprise 2005 64bit version on Windows 2003, 2008 servers and VM ware servers on Enterprise systems of Clustered and standalone servers in enterprise data centres. Patch applications.
• Developed strategies in migration of SQL server from one version to another.
• Designed and created database objects like tables, stored procedures, views, triggers, user defined data types and functions.
• Implementedsecurity and object permissions such as maintain database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Managed database backup and disaster recovery including Point-in-Time recovery.
• Configured database mirroring as part of disaster recovery solution, clustering as high availability solution and replication to achieve scalability of databases and to improve read performance.
• Created and scheduled SQL server automated jobs in a timely manner of daily, weekly and monthly processes.
• Monitored SQL server error logs, job history logs, space usage, customer complaints, tickets, optimizing queries, tracing long running queries and deadlocks.
• Implemented performance monitoring and database tuning using different tools such as SQL Profiler, Database Tuning Advisor.
• Created, modified, monitored, rebuild and reorganized Indexes, Constraints, Views etc.
• Used Performance counters to find the bottlenecks of servers in CPU, Disk I/O and memory devices to improve the server as well as database performance.
• Experience in building SSIS packages (.dtsx) involving ETL process, extracting data from various flat files, excel files and loading into SQL server.

ENVIRONMENT: SQL Server 2000/2005/2008 R2, T-SQL, Excel, Windows 2003/2008 Server, Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, Reporting Service(SSRS).

 

GLOBAL INFO SOLUTIONS, HYDERABAD, INDIA

Role: SQL Server DBA/DEVELOPER                              2010, JULY- 2011, OCT

 

Responsibilities:

• Maintaining SQL Server 2005/2008 R2 servers for day-to-day activities.
• Regular SQL Server Maintenance Activities that include Index rebuilds and updates statistics, Database Backup, Data Imports and Exports.
• Maintained security related activities such as logins and database object permissions.
• Managing Login Authentication and User Privileges for more than 100 users.
• Resolving security issues by creating new roles and granting required permissions to the users at various levels.
• Used log shipping for synchronization of database.
• Extensively used Joins and Sub-Queries to simplify complex queries involving multiple tables, added columns, triggers and worked on index tuning and stored procedure tuning.
• Involved in Optimization and normalization of database and tables.
• Automated and monitored daily administrative tasks including space management, object alteration, database backup and recovery, database status, logs, space utilization, extents, checkpoints, locks and long transactions.
• Part of a team for analyzing and implementing the physical design for database.
• Writing complex Stored Procedures to meet the business requirements.
• Created new database objects like Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Used DTS as an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.

ENVIRONMENT: MS SQL Server 2000/2005/2008 R2, Windows 2000/2003/2008 Servers,  MS Access, Integration Services(SSIS), Business Intelligence Development Studio, Visual Studio 2008/2005, Reporting Service(SSRS).

 

ICICI BANK, HYDERABAD, INDIA

Role: SQL Server DBA/DEVELOPER                                          2009, JAN-2010, JUNE

 

Responsibilities:

• Responsible for installation, configuration and complete administration of different versions of SQL server.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Implementation of robust backup and recovery
• Apply best practices to the SQL server
• Perform database refresh from higher to lower environments.
• Performance tuning using IDERA, Profiler, SCOM, Windows performance monitor and Database engine tuning advisor to analyze and fine tuning of long running queries and stored procedures and slow running
• Monthly auditing of the servers for security, performance and best practices.
• Develop and deploy server reports using SSDT for managerial decisions.

 

ENVIRONMENT:  MS SQL server 2000, 2005, T-SQL, Windows NT/2000/2003.