SUMMARY

• Over 6+ years of IT experience on Database Administration with MS SQL Server technology.
• Experience in System Analysis, Design, and Administration & Development of MS SQL Server 2014, 2012,2008, 2005, 2000, 7.0in Production, QA, and Development environments.
• Hands on experience in Installation and Configuration of SQL Server 2000/ 2005/2008/2008 R2/2012/2014 technology, service packs and hot fixes.
• Experience in ASP .NET MVC and C#.NET, HTML, VBScript, JavaScript, Java.
• Experienced and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Database Snapshot,Log shipping.
• Expert in Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
• Solid experience in performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
• Good understanding in implementing different types of Replication Models such as Transactional, Snapshot, Merge and Peer to Peer.
• Design Data Warehouse, Data Mart, and On - Line Transaction Processing oriented architectures
• Expert in automating the system by using Notification service and creating alerts, jobs and Maintenance plans.
• Experience in Installation and configuration of SSRS, SSIS and SSAS servers.
• Hand full of experience in using third party tools like Redgate,idera, Spotlight, Sql tuner, Sqlexpert, Litespeed etc.
• Administered SQL Server 2005/2008/2008 R2/2012/2014 Instances using Windows Power Shell Scripting.
• Used SiteMinder to create a query scheme which defines the SQL queries to authenticate users against the DB, get attribute information, etc.
• Ample of experience in data warehousing using star schema and snow flex schema.
• Ample of knowledge in Relational Database Management Systems (RDBMS) & Entity Relationship Diagram (ERD).
• Conversant with all phases of Software Development Life Cycle involving System Analysis, Design, Development and Implementation.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).
• Able to work independently and collaborate proactively & cross functionally within a team.

TECHNICAL SKILLS

RDBMS: MS SQL SERVER 7.0/ 2000/ 2005/2008/2008 R2/2012/2014, Analysis Server 2000/2005/2008 , Ms Access 2000/2005.

Databases Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio (BIDS), Database Engine Tuning Advisor(DTA), Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Jobs and task creating and scheduling, MS Visio, Crystal Reports 10.0, SQL reporting, SSIS

Programming Languages: SQL, TSQL, XML, PL/SQL, C, C++, VB 6.0, Perl, HTML, XML.

Web Tools: ASP.NET, ASP.NET MVC, ASP, JavaScript, ExtJs, MS-Front Page, Internet Information Server(IIS),FTP,TCP/IP,LAN,MS-Outlook Express

Operating Systems: Windows 95/98/2000/2003/2008 R2/2012/XP/NT 4.0, Linux, Novell Netware, MS-DOS.

Utility Tools: MS Office, MS Project, Clear Quest, Visual Source Safe 6.0, Rational Clear Case.

ETL Tools: SSIS(SQL Server Integration Services), DTS(Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Server Developer/DBA

Responsibilities:

• Installed sql servers, created databases based on business needs and performed dba activities like backups, restores, maintenance work, created logins and granted access to users accordingly.
• Worked on migrations from older versions to SQL 2014.
• Configured ALWAYS ON AGs, Integration service catalogs in SQL 2012 and 2014.
• Create Proxies to run the SSIS packages in SQL agent jobs.
• Worked on creating SPNs for allowing Kerberos authentication to resolve double hop\linked server connectivity issues.
• Used JavaScript for client side validations.
• Develop SSIS Packages to transform data from excel/Access file to SQL Server database.
• Worked on SSRS installations and configured reports URL.
• Provided documentation on Disaster Recovery plans.
• Worked on infrastructure build process through go-live or go-dev.
• Designing and Development of the Web pages using ASP,ASP.Net 1.1/2.0(VB,C#)
• Configured SQL instances in different domains to satisfy business requirements.
• Automated backups usingIdera SQL Safe and configured SQL instances to use Idera diagnostic manager tool.
• Deployed reports on to the report manager and presented them to the users creating custom vb.net applications and asp.net pages
• Created reports using SSRS from OLTP and OLAP data sources and deployed on report server.
• Migrated database from SQL Server 2008 R2 to SQL Server 2012.
• Worked extensively in performance tuning of databases including query tuning, server tuning.
• Created and scheduled maintenance plans for Database backups, log backups and cleanup.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Assisted data migration from ODBC compliant sources (Oracle)/legacy systems to SQL Server through DTS packages and bcp utility.
• Automated backups, reorgs, restores, check error logs, offline dbs, copy dbs, check db status etc through scripts.
• Resolvedlong time running queries, Blocking, CPU/IO/Memory/Tempdb bottleneckissues by making use of dmvs.
• Developed sql codes and created stored procedures based on business needs.
• Automated the process of monitoring space and backup reports.
• Worked with end users and application team to develop queries based on business needs.
• Created central database to store details of all instances.
• Implemented all the available high availability options.
• Monitored databases/instances for uninterrupted business support.
• Experiencein trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Work closely with app team to develop test plans and go live strategy.
• Provided documentation for the implemented procedures which involves Go Live activities and support work.

Environment: MS SQL Server 2014/2012/2008 R2/2008/2005 Enterprise Edition, Windows Server 2003/2008/2012 , Business Intelligence Development Studio(BIDS) - SQLServerIntegrated Services (SSIS), Net Framework 3.5, VB.Net, C#, SQL Server Reporting Services (SSRS), JavaScript, SQL Profiler, Database engine tuning Advisor, T- SQL

SQL Developer

Responsibilities:

• Ensure regular Database backups and implementing tests on backups and generating reports.
• Creating databases and logins with permissions in SQL server 2012 as per the developer’s request.
• Taking Database fullBackup, Transaction log backup & differential backup in daily Routine.
• Solved Helpdesk tickets on Daily Basis for Production Issues.
• Guided Technical Services team members 24x7 in resolving SQL Server 2012 database issues.
• Worked on database activities not limited to resolving performance issues, utilizing high availability options, create/drop/offline database, solving job failures, start stop sql services.
• Monitored database status, instance status, blocks, errorlog.
• Created and monitored backup and space reports.
• Provided 24 x 7 Production support for the database and application issues.
• Created logins, users, roles and granted access.
• Developed a generic table driven Business Rules Engine(BRE) for extracting and transforming data based on rules/condition using SSIS,T-SQL and VB.Net.
• ManagedDatabase backupand restorein all environments.
• Developed backup plan and ensure all databases are backed up.
• Migrated SQL Server instances from 20 .
• Hands on experience in configuring, maintaining SQL 2012 instances.
• InstalledSQL Server 2012, applied service packs and security fix for production servers.
• Managed Multiple 2012 SQL Servers in Production, Development and QA Environments.
• Worked on Contained Databases, Columnstore indexes, AlwaysOn availability groups and other features of SQL Server 2012.
• Develop, modify and maintain Database support procedures.
• Resolved the Memory/IO/CPU/TempDB bottlenecks to achieve performance by making use of Windows Performance counters, SQL traces and DMVs.
• Identified improper indexes and optimized them for better performance.
• Developed and deployed ETL packages using SQLServerIntegrated Services (SSIS).
• Generated reports using SQL Server Reporting Services (SSRS).
• Fine-tuned Stored Proceduresto improve performanceandcaptured SQL Traces usingSQL Profiler.
• Resolved performance related issues like long running queries, Blocking and Deadlocks.
• Worked on DatabaseupgradeandMigration.
• Worked oninstallation, configuration,andupgradeofMS SQL Server R2 servers.
• Worked on building queries, stored procedures that meet business needs.
• Experiencein trouble shooting and fine-tuning of databasesfor itsperformance and concurrency.
• Worked on relocating of Databases from one server to another server.
• Set up ports for different environments.
• Configured SSRS using configuration manager, created and maintained security roles and created new reports.
• Performed maintenance activities like analyzing/rebuilding indexes, update statistics based on business needs.
• Gathered workload and collected Profiler traces and analyze them using database engine tuning advisor.
• Implemented high availability options like Log shipping, Database mirroring, Clustering and Replication.

Environment: MS SQL Server 2012/2008/2005/2000 Enterprise Edition, Business Intelligence Development Studio(BIDS) - SQLServerIntegrated Services (SSIS), SQL Server Reporting Services (SSRS), SQL Profiler, Database Tuning Advisor, Database Mail, Notification Services, T- SQL, JavaScript, Net Framework 3.5, VB.Net, C#, Windows server

Confidential

System/Data Analyst (Change Control Specialist)

Responsibilities:

• Confidential 14 certified professional.
• Worked on software upgrades for Confidential customers; Confidential, Linux, SQL and TMS software upgrades.
• Worked with tools like BTEQ, Fastload, Multiloadetc
• Provided dedicated support for Confidential TDBMS
• Completed multiple SLES moves and upgrades
• Upgraded the customers system remotely using Confidential Database and SQL
• Worked on various upgrades like Patch upgrades, major and minor upgrades, Viewpoint upgrades, Data Mover upgradesetc.
• Worked on Aster, Hadoop systems to perform upgrades on the customer systems
• Spoke to different customers throughout USA to schedule outages of the systems
• Handled different levels of incidents during the upgrades
• Supervised and trained/guided different colleague on different upgrades
• Attended different training on hardware and software for Confidential and SQL database

Environment: Tearadata database, MS SQL Server 2005, BTEQ, Fastload, Multiload, Analysis Services, Aster, Hadoop, TDBMS, SLES1 9/10, Viewpoint, Datamover.

Confidential

SSIS/SSRS/Developer

Responsibilities:

• Configured and Installed SQL Server 2005.
• Developed, modified and optimized complex stored procedures, triggers and user defined functions.
• Tested to optimize the Stored Procedures and Triggers to be used in production.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Configured Transactional replication between Primary Server and three Read - Only servers, with separate Distributor server and experience in troubleshooting replication problems.
• Resolved the SQL Server 2005 upgrade hurdles and successfully Migrated SQL 2000 DTS packages to SSIS using Upgrade advisor and Package Migration wizard.
• For complex packages like password protected packages, packages created using SQL Native client used DTS Xchange tool.
• Additionally, designed and implemented a disaster recovery system.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Maintained the use of disk space, memory, processor and connection.
• Implemented regular database backup and recovery tests.

Environment: MS SQL Server, Windows Server, SQL Agent, SQL Profiler, DTS, T-SQL.

Confidential

BI Developer (SSIS, SSRS)

Responsibilities:

• Very knowledgeable on SSIS, SSRS, Business Intelligence reporting applications.
• Upgraded SQL Server 2000 DTS Packages to SSIS for uploading various formats of files and databases to MS SQL Server 2005 using SQL Server Integration Services (SSIS).
• Migrated data from various data sources using SSIS Transformations like Aggregate, Lookup, Conditional-split, Merge Join, WebService task and Sort.
• Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
• Designed and deployed SSRS reports with drill down, drill through and drop down menu options and parameterized and linked reports.
• Scheduled and deployed reports using SSRS to generate weekly, monthly and quarterly reports including current status if required by the client or the management meeting strict deadlines
• Designed Solid detail design documentation for various SSIS conversion process.
• Configured Logging, Auditing, Sending mail alerts and check point files on production servers using SSIS.
• Using Team foundation server(TFS) to keep track of SSIS packages and SSRS reports.
• Using SSIS developed Interfaces for extracting and loading data from various sources like Intersystem cache database, SQL Server 2005 and CSV files.
• Using SSIS Implemented Incremental upload method on the tables for loading data based on new/existing records
• Developed SSIS Interface to read and load the Health Level (HL7) file into data warehouse
• Used various SSIS tasks & transformations like Pivot, Unpivot, conditional split, XML task, Script task, FTP and Send mail task
• Extracted large volumes of data from different data sources and loaded the data into target data by performing different kinds of transformationsusing SQL Server Integration Services (SSIS).
• Installing report server configurations.

Environment: SQL Server 2000/2005, T-SQL, Data Transformation Services (DTS), Reporting Services (SSRS), Integration Services (SSIS),Windows OS.