SUMMARY

• Over 9 years of experience inSQL Server Database Administration and development dat includes providing end to end administrative support and designing and developing database applications using MSSQLServer's 2017,2016,2014,2012, 2008 R2, 2008, 2005, 2000.
• Extensive experience in Database High Availability and Disaster Recovery solutions using Mirroring, Log Shipping, Replication, Clustering (Active - Active/Active-Passive), Always-On Availability.
• Worked in Analyzing teh Project Scope at an Architect level with Business and Implemented teh Project in time in Budget and Involved in Complete SDLC.
• Experience in design and build of clusters includes Active/Active and Active/Passive Configurations. Also, worked with multi node clusters up to 6 Nodes.
• Extensively worked onSQLServerMigrations and upgrades fromSQL2005/2008/R2 toSQL2014,2016, and 2017.
• Extensive experience in solving performance issues to alleviate teh CPU, Memory and Disk IO Pressure and resolving slow running query issues.
• Implemented and maintained Database Replication and Developed teh stand-alone Database for Reporting Servers.
• Expertise in Always- On Availability Groups (AG) And HA/DR setup and configuration.
• Experience in working and migrating teh application with Tera bytes of Database with Size is of 107 TB and average database size is 2 TB.
• Strong Database Objects development - Tables, Views, Triggers, Stored procedures, Functions, Cursors, and T-SQLbatches.
• Involved in design and migration of SSIS and SSRSserversfrom one storage block to other storage block and change in VLAN forserversand addingserversin Load balancer
• Involved in design and consolidation of SSIS and SSRSserverusing Autosys, Fname and Load balancer techniques
• Extensively worked in OLTP & OLAP environment dat includes Production (24x7), QA and development databases inSQLServer.
• Experienced in installing, configuring and deploying MS SQL Server suite of Products include SQL Server Integration Services, SSRS.
• Experience in migration of Data from Excel, Flat file, Oracle9i/10i to MSSQL Server by using SSIS, BCP and DTS utility.
• Extracting, Transforming and loading of data usingSSISand DTS;
• Experience in data normalization and data modeling using Erwin;
• Working Experience in documenting complex database applications, and data;
• ImplementedSQLqueries using DML and DDL statements to extract large quantities of data from multiple data points on MS SQLandTeradata SQL Assistant.
• Experienced in using DataStage (9.1, 8.1) Tools like IBM Info sphere DataStage Designer, Info sphere DataStage Director for developing jobs and to view log files for execution errors.
• Good experience in writing MDX queries, creating cubes, and data source views, named queries, dimensions and deploying of analysis services projects using SQL Server Analysis Services (SSAS) 2005/2008/2012/2014/2016.
• Implemented CDC (Change Data Capture) and Change Tracking in SQL Server 2008/2012/2014 for capturing changes for data warehouse environment.
• Experience in overcome teh roadblocks and provide solutions and implement migrations for hard coded old applications withSQLServerInstance name and IP addresses
• Experience with Table Partitioning and implemented Sliding window partitioning for Application Tables.
• Exposure toSQLserver2014 Polybase, Hadoop, Azure, AWS.
• Exposure to multiple database platforms like Oracle, MySQL and Mongo DB.
• Experience in understanding and choosing single and elastic databases as per billing and performance parameters
• Good interpersonal, Analytical and Communication skills and a team player
• Design database Backup and Restoration Strategy with LIGHT SPEED and RED Gate tools.
• Expert in data transformation services and Bulk Loads with SSIS and BULK INSERT ETL operations.
• Experience in Azure (Iaas, Pass, Sass).
• Experience in migrating SQL Server Databases into Azure.
• Involved in effort estimation for teh requirements for teh project.
• Co-ordinate with all teh business users and process owners to complete SDLC processes.
• Worked TEMPeffectively with Business Analysts and Project managers for assigned tasks and deliverable timelines.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2017/2016/2014/2012/2008 R 2/2005/2000/7.0, Oracle 11i/10g MySQL 4.1, PostgreSQL and MS Access 2016/2010/2007/2003

Languages: T-SQL, C/C++, Visual Studio 2015/2005/2003, XML, HTML, ASP.NET, VB.Net.

Network Protocols: TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP, Cisco Routers And switches

Cloud Services: MS Azure Cloud Service (Iaas, Pass, Sass), AWS (EC2, S3, RDS)

Web servers: IIS, Tomcat, Jetty, Netscape Enterprise Server, BEA WebLogic and IBM WebSphere.

Data Mining Tools: Microsoft Analysis Services(SSAS), Red Gate tools

Operation Systems: Windows Server 2016, 2012, 2008R2 EE, Windows Server 2008 (SE, EE), Windows Server 2003 EE, Windows 2000 Server/Advanced Server and Windows, UNIX, Solaris.

Version control: MS Team Foundation Server (TFS), VSS, CVS, PVCS, Clear Case

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data transformation services (DTS), IBM Data Stage, SQL Server Data Tool (SSDT), Crystal Reports.

High Availability: Always-ON, Failover Clustering, Network Load Balancing, Log Shipping

Data modeling tools: Erwin, MS Visio, ERStudio, and Power Designer

Monitoring Tools: WUG, SCOM, Mom, New Relic, Zabbix, Java melody, BMC Patrol, Idera, Spot light, SQL Server Profiler and Performance Monitoring, MDW

Reporting Tools: Business Objects/Crystal Reports, Tableau, SSRS (Report Builder)

Virtualization: VMware 3.1/4, VMware Fusion, MS Virtual Server 2005 R2, MS Terminal Server 2008

MS Office: Word, Excel, Access, Outlook, Outlook Express and Power point.

Data migration: DTS, SSIS, BCP, SQL Loader, Import/Export Wizard.

Other Tools: GlodenGate, RedGate, TOAD, WMI, COM, MSF, MOF, JAMA, Microsoft Silver Light, Share Point Server, Perfmon, Resource Monitor, Commvault, Benchmark factory, SQL optimizer for Oracle.

PROFESSIONAL EXPERIENCE

Confidential, San Leandro, CA

SR. SQL Server DBA/Developer

Responsibilities:

• Installed, Configured and ManagedSQLServer 2005/2008/2008 R 2/2012/2014/2016/2017 Serversin production, and non-production environments.
• Documented teh upgrade path toSQLServer2014, 2016, and 2017 and handled teh upgrades from 2000 to SQL 2005, 2008/2008R2 toSQL 2014/ 2016/2017 for enterprise applications.
• Worked in Analyzing teh Project Scope at an Architect level with Business and Implemented teh Project in time in Budget and Involved in Complete SDLC.
• Implemented and maintained Database Replication and Developed teh stand-alone Database for Reporting Servers.
• Expertise in Always-On Availability Groups (AG) and HA/DR Setup and Configuration.
• Experience in working and migrating teh application with Tera bytes of Database with size is of 107 TB and average database size is 2 TB.
• Experience in overcome teh roadblocks and provide solutions and implement migrations for hard coded old applications withSQLServerInstance name and IP addresses
• Implemented CDC (Change Data Capture) and Change Tracking in SQL Server 2008/2012/2014 for capturing changes for data warehouse environment.
• Implemented TDE Encryption, Decryption, EFS & Auditing .
• Analyze and redesign optimization query to improve performance as per application specific requirement
• Experience in Design, Architecture and providing solutions
• Involved in design, consolidation SSIS and SSRSserverusing Autosys, Fname and Load balancer technologies
• Involved in design and migration of SSIS and SSRSserversfrom one storage block to other storage block and change in VLAN forserversand addingserversin Load balancer
• Expert in Using DMVs, DMFs, Perfmon for identifying bottlenecks and resolving.
• Involved in effort estimation for teh requirements for teh project.
• Involved in Creation, Development and Deployment ofSSISpackages inSQL Server2008\r2 and 2012.
• Initially loaded data into staging tables from Facets using different transformations, control flow tasks, loop containers and data flow tasks, tan moved teh data into different Schema's.
• Investigated Data Discrepancies between Various Source Systems and teh Data Warehouse dat affect teh flow of data through EDI for Government Compliance.
• Responsible for monitoring and making recommendations for Performance improvement in hosted databases
• Support softwaredeveloperswith database operations including teh development of complexSQL, tuning of DML and teh creation of stored procedures.
• Extensive Testing on teh Performance of teh Stored Procedures.
• Wrote and integrated Stored Procedures to generate teh Reports.
• DesignedETLpackages dealing with different data sources (SQL Server, Flat Files) and loaded teh data into target data sources by performing different kinds of transformations usingSQL Server Integration Services (SSIS)
• Responsible for codingSSIS processes to import data into teh Data Warehousing from Excel spreadsheets, Flat Files and OLEDB Sources.
• Involved in building and maintaining SSISPackages to import and export teh data from various data sources using BIDS based on teh design data models.
• Integrated TFS withSQLdata tools to manage MSBI stack packages properly in DEV, QA and PROD environments using check in and checkout and have maintained history for every minor change.
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Co-ordinate with all teh business users and process owners to complete SDLC processes.
• Worked TEMPeffectively with Business Analysts and Project managers for assigned tasks and deliverable timelines.
• 24/7 Production On-Call Support.

Environment: SQL Server 2017/2016/2014/2012/2008 /R2/2005/2000, Mirroring, ERWIN 9.7, Windows Servers, Linux, Suse Linux, T-SQL, SSIS, SSRS,SSAS, SSDT,IBM Info sphere DataStage, DataStage Administration, Oracle 11i/10g/9i, TFS, VSS, lite Speed, XML windows Services, MS-Excel, MS Azure, MDW, SQL Server Replication, Business Objects,, Cluster Environments, Red Gate, CDC, TDE, SSL, Active directory, Powershell, IIS, SharePoint,, MS Access, Solar winds DPA, Idera, MySQL, AlwaysON. Quest Spotlight, Quest LightSpeed, Windows 2003/2008/2008 R2Servers, VMWare ESXi 4.0/ESXi 5.0.

Confidential, SFO CA

SQL Server DBA/Developer

Responsibilities:

• SQL SERVER 2005/2008/2008 R2 Production Environment.
• Fixed teh failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and at teh SQL SERVER LEVEL.
• Implemented SIDE BY SIDE Migration of databases from SQL Server and SQL Server .
• Involved in Normalization, Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Handling Memory configurations for SQL Server 2000 and SQL Server 2005/2008 on Windows 2003
• Implemented teh new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA, SQLCMD and dedicated admin connection and Compressed Backups.
• Created Documentation for steps need to be taken while upgrading teh SQL server 2000 to SQL server 2005.
• Work based on Business Intelligence (BI) and Data Warehousing in SQL Server 2005
• Implemented new T-SQL features added in SQL Server 2005 dat are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Migrated DTS packages to SSIS packages and maintained teh archival data.
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning
• Prepared Documentation for teh Disaster Recovery plan, Worked in Active passive cluster environment
• Wrote and debugged Stored Procedures and (DDL /DML) Triggers, Functions as per client requirements
• Extensively worked on trouble shooting and fine-tuning of databases for its performance, Rebuilding indexes with different fill factors and update statistics manually
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and handling maintenance Jobs including backups and restores.
• Hands on experience in trouble shooting database issues. Update statistics, database integrity check and Backup operations
• Extensively used lite speed backup with MS SQL SERVER 2005/2008.
• Expertise in SQL server Reporting Services(SSRS).
• Monitoring SQL server performance using profiler to find teh performance and dead locks.
• Worked on call 24/7 Support on weekly basis

Environment: SQL Server 2000/2005/2008 with clustering, Replication, T-SQL, Windows bit, DTS, SSIS, Profiler, Oracle 10g, TFS, Lightspeed, Crystal Reports, XML, Web Services.

Confidential, Nashville, Tennessee 

SQL Server DBA

Responsibilities:

• SQL Server Database Administrator
• Installed SQL Server 2008/2005 on windows 2003/2008 on clustered environment.
• Workedon32-bit,64-bitclusteredenvironments.
• Performed Node Injectionfor teh enhancements of hardware in teh Clustered environment.
• Installedandconfiguredandmaintained failover clusteringforSQL SERVER 2005.
• Migrationof databases fromSQL Server 2000/2005toSQL Server 2005, 2008.
• Monitored Log shippingas high availability solution.
• ConfiguredServer Memoryfor maximumPerformanceand TEMPeffective utilization.
• Monitoring SQL server performance usingprofilerto find performance anddeadlocks.
• IntegratedPerformance monitorandSQL tracesto have better graphical analysis to find system bottlenecks.
• MigratedDTSpackages toSSISpackages.
• Implemented and administered Active directory services, Trust relationship and enforced Domain wide Group policies.
• Administered and maintained windows 2003 server-based network of 40 servers.
• Implemented RAID1 and RAID5 on mission critical servers.
• Proficient in working knowledge of Clustering and SAN.
• UsedDynamic Management Views (DMV)for monitoring teh performance of teh server.
• Worked withIP MonTool by setting upalertsfor teh Monitors of various SQL Servers.
• PerformedDatabase Integrity Checks, updated Database Statistics and performedRe-indexing through Maintenance Planner.
• Maintaining teh databaseconsistencywithDBCCat regular intervals.
• CreatingSQL Server Loginsand assigningRolesandAutantication Modesas a part ofSecurity Policiesfor various categories ofUser Support.
• CreatedMaintenance Plansdat helped in TEMPeffective disk utilization and index maintenance.
• TEMPEffectively managed disk space usingLITE SPEEDfor Data base Backups.
• Exportall Maintenance Packages and brought them underSource control.
• Created, Scheduled and monitoredSQL Server Jobs,making sure jobs run successfully every night.
• Tunedstored procedures,triggers,viewsand adding/changing tables for data load and transformation, anddata extraction.
• Extensively worked onProduction supportand involved in trouble shooting SQL servers in various levels.

Environment: SQL Server 2000/2005/2008 with clustering, Replication, T-SQL, Windows bit, DTS, SSIS, Profiler, Oracle 10g, VSS, Lightspeed, Crystal Reports, XML, Web Services.