Sql Server Developer

Vivek Chandra

719-***-**** ****************@*****.***

●Outstanding expertise in data mirroring, log shipping, performance tuning, query optimization, and ensuring rigorous data integrity in machine-critical and high-volume Terabyte database environments.

●Proficiency with SSRS (SQL Server Reporting Services), SSIS (SQL Server Integration Services), and SSAS (SQL Server Analysis Services).

●Constantly focus on optimizing application performance, reliability, security, and usability.

●Expert at creating triggers, objects, views, stored procedures, and databases using T-SQL and PowerShell.

●Solid ability to extract, manipulate, and analyze complex data to generate detailed reports

●Efficiently balance competing demands, resolve technical challenges, and master new technologies.

SKILLS: Operating Systems: Windows Vista, XP, Windows 95/98, Windows NT 4.0, Windows 2000/2003/2008, Dos, UNIX, AIX, Solaris 2.x/7, LINUX and Sybase SQL AnyWhere.

Database: MSSQL 2000/2005/2008/2008 R2/2012/2014/2016, MS Access, MySQL 4.x/5.1/5.5/5.6, Oracle 9i/10g/11g/12c, DB2/UDB, OLTP, OLAP and Data warehousing.

Tools: MS SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), SQL Profiler, PostgreSQL, VISIO, Enterprise Manager, SSMS, i3-Precise, Idera Admintoolset, SolarWinds, Microsoft Azure.

Hardware: Compaq, Dell and HP servers/desktops, laptops, Cisco routers, SUNSPARC

EDUCATION/ CERTIFICATION & SCHOLARSHIP:

●B.Sc. (Civil Engineering), National Institute of Technology, PATNA, INDIA.

●Mini MBA: MyBkskool.com

●SQL Server Administration, UNITEK College, Fremont, California

●Oracle Administration Course I and II, Oracle University, Pleasanton, California

●Management Development Course (Tata Management Development Centre, Dimna Lake, India)

●Certified ScrumMaster (CSM)

●ITIL Foundation Certificate in IT Service Management

●National Talent Search Scholarship (National Council of Educational Research and Training, New Delhi, Government of India)

●Currently enrolled in MBA in West Texas A&M University

●Also accepted in class of 2020 Purdue Executive MBA

PROFESSIONAL EXPERIENCE:

CenturyLink, Broomfield, CO September 2017- Present.

Database Developer

Utilize SQL Server, SSIS, SSRS, DB2 UDB, Oracle, Visual Studio, Microsoft SQL Server Management Studio, SourceTree and Git to develop packages and deploy them in Production environment. Migrate Access databases to SQL Server. Create new tables for data modeling.

Summit Utilities Inc, Littleton, CO January 2015 – July 2017

●Apply strong technical expertise toward playing an integral role in Cayenta ERP implementation.

●Employ SolarWinds to investigate performance issues with Cayenta, decisively select new monitoring vendor, and contribute to development of customer self-service module within application.

●Spearhead upgrade of SQL Server 2005 to SQL Server 2008 R2 and subsequently to SQL 2012.

●Maintain GIS database on SQL Server 2014. Run SQL Health utility and perform SQL Tuning on this box.

●Perform thorough database disaster recovery testing via Abtech and AppAssure tools. As part of Safety Committee, recommend ways to improve the pathways and identify danger zones to Safety Director.

●Configure replication for GIS and leverage SQL queries to facilitate performing tuning and optimization.

●Accurately compile technical documentation associated with merger of Summit Utilities and AOG.

●Install SQL Server 2016 for databases related to integration project of the AOG and Summit Utilities Inc.

City and County of Denver, Denver, CO September 2014 – January 2015

SQL DBA

●Migrated 12 DTS packages written using Sybase SQL Anywhere and SQL Server 2000 to SQL Server 2012 SSIS packages for Denver Police Department for TeleStaff ERP system.

●Worked with project manager and business analyst for this.

City and County of Denver, Denver, CO March 2014 – July 2014 September 2014- January 2015

SQL DBA

●Participated in migration of data from Hatrack systems for Sheriff Office (Criminal Justice Information Systems) to Atlas (Emerald City ERP system) running on SQL Server 2008 R2.

●100% DBA Support for SQL Server 2005, 2008, 2008 R2 and SQL 2012.

●Responsible for administration, maintenance and availability of enterprise Production SQL server environments including MS SQL failover clusters and replication.

●Working with Integration, Reporting, and Operations teams on new initiatives & long term strategy to ensure integrated database systems. Advise on physical data model and implement changes.

●Coordinating with technical project managers, developers and other team members to coordinate database requirements across projects.

●Presentations to senior management using custom metrics gathered by monitoring for overall performance of SQL Server and next steps for improvements where possible.

●Responsible for capacity planning, working closely with Infrastructure group to allocate appropriate database resources on servers.

●

Comcast, Greenwood Village, CO Dec. 2013 – Jan 2014

Database Administrator

●Supported MySQL Server database migration related tasks: installation, configuration, data migration and performance tuning.

●Involved in database design, coding best practices.

●Involved in Security model design for applications.

●Involved in Database – Application server architecture.

MI-JACK, Chicago, IL Nov 2013- Dec 2013

SQL DBA

●Supported MI-JACK performance tuning initiative for their database running on DB2 UDB. Also, supported migration to SQL Server 2012.

●Attend meetings for discovery of SQL Server tasks required, insuring all requests are translated as tickets in the corporate ticketing system.

●Coordinate with offshore team to track, fulfill and resolve database related incidents and requests within defined SLAs.

●Collaborate with the Service Delivery team with respects to performance tuning slow running Stored Procedures and optimizing Indexes.

T Systems, Scottsdale, AZ June 2013 – Aug. 2013

SQL DBA

●Migrated SQL Server 2008 R2/SQL Server 2012, MySQL and DB2 UDB databases to TSYS cloud for its global client (DHL).

●Monitored SQL Server by creating and evaluating policies using Policy Based Management.

●Migrated DHL client’s databases to T-System datacenter.

●Database patches, scripting tables, indexes, constraints, stored procedures, and user-defined functions from production systems to replicate & create database installers for a novice development environment.

Airmethods, Centennial, CO June 2012 – Dec. 2012

System Administrator

●Supported RAMCO ERP System (Aviation Module) running on SQL Server 2005, SQL Server 2008 R2 and SQL 2012. Also, supported pilot 411 system running on Oracle 11g. Maintained replication and setup database maintenance plans.

●Supported monthly release on production and training environment for RAMCO Systems. Document the process and raise tickets with RAMCO Systems Technical Team.

●Wrote stored procedure for Journey Log Integration.

●Installed hotfixes supplied by RAMCO Systems.

●Utilized SSIS to create packages for loading data in SQL server from external sources.

●Created Fact and Dimension tables. Created cubes using SSAS.

●Applied Patches to SQL Server and perform Backup and Restore of training and Pre-Production environment.

●Evaluated EtQ software for Safety department.

Mercury Payment Systems, Denver, CO April 2012 – June 2012

DBA / Developer

●Worked on SQL Server and MySQL databases. Migrated database from MySQL on Linux to MySQL 5.1 on Windows.

●Participated in daily scrum meetings.

●Installed MySQL 5.1 on boxes and configured them for Master/Slave/Slave configuration.

●Participated in daily scrum meetings and planning meeting.

First Data, Greenwood Village, CO Feb 2011 – Feb 2012

Project Lead/Database Administrator

●Supported SQL Server databases located on various datacenters in Chandler, Cincinnati, Sacramento and Charlotte running on SQL 2005, SQL 2008 and SQL 2008 R2.

●Led and managed the development effort for creating reports using BIDS in SSRS.

●Act as SME for SQL Server databases for two datacenters.

●Performance tuned complex queries running on SQL Server.

●Verify the Source Code before deployment in QA and Production environment.

●Created Triggers, Objects, Views, Stored Procedures, databases using T-SQL and PowerShell.

●Utilized SSIS to create packages for loading data in SQL server from external sources.

●Created and deployed Cubes using SSAS.

●Installed Service Packs and Patches and upgraded SQL Server 2005 to SQL 2008 and SQL 2008 to SQL 2008 R2. Updated global master database inventory.

●Monitored SQL Server by creating and evaluating policies using Policy Based Management.

●Utilized MySQL for database creation, import, security and load activity.

●Managed and lead the Disaster Recovery for CMS Worldlink databases servers for TASQ application.

●Evaluated and install Idera products namely SQL Doctor, SQL admin toolset for TASQ and Worldlink Server.

●Managed the data center consolidation project. Migrated databases from legacy servers to better hardware.

●Monitored Replication and Mirroring installed on the servers.

●Monitored Oracle Databases and administer them using TOAD for Oracle.

●Utilized i3-precise to monitor servers across all the data centers.

●Utilized CA Service Desk for managing the change.

●Evaluated servers and harden them for security purpose.

●Performance tuning for end user running applications like TASQ, MTOS, Government of Alabama/Puerto Rico tax

●Performed index rebuilds and maintain database partitions.

FedEx, Milwaukee, WI Jan 2011 – Feb 2011

Database Advisor

●Created star schema using fact and dimension tables.

●Led projects on Oracle, SQL Server, and Business Objects.

●Transported objects from DEV to QA instance. Developed cubes.

●Created reports using SSRS. Participated in SDLC change process meeting with developers and project managers.

●Worked as project manager to get programs developed using .NET and ASP.NET using Agile Development.

OnTargetJobs Inc, Englewood, CO May 2010 – Nov 2010

Database Administrator

●Supported Medhunter, Baybio, Regional Help Wanted and Hcareeers.com Job Boards.

●Using Scrum, worked with development, product manager and project manager to create databases upgrade scripts.

●Deployed Database objects across QA and production environment.

●Utilized RedGate SQL Compare and Data Compare tools to create synchronization reports across different databases.

●Maintained regular contact with the product manager throughout the development cycle to ensure each step of implementation meets the business requirement.

●Performed on Call Support for SQL Server and Oracle databases.

●Resolved production tickets after daily triage call with the management.

●Supported websites running on SQL Server and MySQL.

●Installed pgAdminIII and supported Hcareers.com job site running on PostgreSQL.

●Utilized Erwin to create logical database diagram.

●Developed Stored Procedures for contract based feed jobs.

●Performed backup on datadomain using datadomain’s deduplication technology.

●Created gold standards for Virtualization project.

●Created fact tables, dimension tables and cubes. Utilize SSRS and SSAS for analyzing data.

●Maintained centralized repository for enterprise level instance/schema information.

●Created Microsoft’s SCOM alerts on all production boxes.

●Maintained Database Versions on Development, QA and Production Environment using TortoiseSVN tools.

●Developed, deployed and monitored SSIS Packages.

●Worked on Database Partitioning and Snapshot Isolation in SQL Server 2005 and SQL 2008.

●Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

Wells Fargo, San Leandro, CA Nov. 2009 – March 2010

Database Administrator

●Utilize Eclipse IDE for product development and upgrade script preparation.

●Deploy application in QA environment.

●Created SSIS packages using SQL 2008.

●Ran daily and monthly Jobs to support Wells Fargo reporting needs.

●Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

Williams Sonoma Inc., San Francisco Oct. 2008 – Sept. 2009

Database Administrator

●Relocation of Databases from one server to another server using attach and detach databases.

●Supported Teradata data warehouse. Performed migration of databases from SQL Server 2000 to SQL Server 2005.

●Wrote the SSIS packages in SQL 2005.

●Migrated DB2 databases to Oracle using Death Panther platform (middleware software developed internally).

●Utilized Data Pump utility to load data for development and end users.

●Extensively worked on Dynamic Management Views (DMV’s).

●Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.

●Worked on Database Partitioning and Snapshot Isolation in SQL Server 2005.

●Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.

●Implemented SQL Server 2005 new concepts like database portioning, snapshot isolation, database snapshot and DDL triggers.

●Rebuilding the indexes at regular intervals for better performance

●Designed and implemented comprehensive Backup plan and disaster recovery strategies.

●Implemented Log Shipping between two instances of servers

●Involved in trouble shooting and fine-tuning of databases for its performance and concurrency

●Monitored and modified Performance using execution plans and Index tuning.

●Recovering the databases from backups in disasters.

●Used DTS packages to move logins and jobs from one server to another server.

●Expertise in SQL Server Analysis Services (SSAS). Expertise in SQL Server Reporting Services(SSRS)

●Monitoring SQL server performance using profiler to find performance and dead locks.

●Maximizing performance and uptime in production environment.

●Analyze long running slow queries and tune the same to optimize application and system performance.

●Set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and setup ideal memory, min/max server options.

Autonomy, Pleasanton, CA Dec. 2007 – Aug. 2008

Senior Database Developer/Admin

●Autonomy is the largest email archiver in the world with clients including Bank of America, Citigroup, Morgan Stanley, Wachovia etc. Recently it got bought by HP in a six-billion-dollar deal.

●Analyzed the present database schema and application.

●Suggested the modifications to schema, indexes, adhoc queries and stored procedures for performance improvement.

●Developed the schema modification scripts and stored procedures.

●Developed Automatic reindexing scripts.

●Testing the scripts and preparing package for next release.

Callidus Software, San Jose, CA Nov. 2006 – Dec. 2007

Senior Database Administrator

●Design a comprehensive monitoring process for a SQL Server 2000, 2005 and 2008

●Callidus is the premium software company in the sales force compensation domain.

●Worked with developers and project managers using agile development process to create the database upgrade script for version releases.

●Performance tuned number of stored procedures.

●Data extraction and loading from legacy flat files into production using BCP, DTS and SSIS.

●Managed database by scheduling daily maintenance jobs like index optimization, de-fragmentation etc.

●Database sizing and recommendations

●Customized Backup and restore plan designing and scripting.

●Customized centralized database maintenance system design, development, testing and implementation.

●Installed and managed SQL server on windows 2003 cluster.

●Reorganized databases files to accommodate the space issues on production servers.

●Wrote custom scripts to monitor jobs and blocking issues to generate email alerts.

●Day to day maintenance and troubleshooting any issues.

●Refreshing/restoring database in development / test environments.

Environment: Windows2000/2003 clusters, SQL Server 2000/2005, OLTP, Terabytes data, Replication, Log Shipping, MOM, VSS, XML and .NET

Spansion, Sunnyvale, CA Jan. 2006 – Nov. 2006

Database Engineer/Administrator

●Spansion is a sister company of AMD and it operates in the memory chip domain.

●Supported datacenters located in Tokyo, Thailand and Sunnyvale.

●Migrated databases from AMD datacenters to Sunnyvale datacenters.

●Responsible for maintaining the high volume OLTP databases.

●Installed and managed SQL server on windows 2003 cluster.

●Worked with developers and resolved lot of blocking and locking issues by rewriting queries and T- SQL stored procedures.

●Performance tuned number of stored procedures.

●Planed Backup and recovery strategy and implemented.

●Implemented data move strategy for reporting purposes using T-SQL, BCP, DTS and SSIS.

●Reorganized databases files to accommodate the space issues on production servers.

●Managed database by scheduling daily maintenance jobs like index optimization, de-fragmentation etc.

●Wrote custom scripts to monitor jobs and blocking issues to generate email alerts.

●Day to day maintenance and troubleshooting any issues.

●Involved in data migration from Oracle, Sybase and IBM sources to SQL server for reporting.

●Refreshing/restoring database in development / test environments.

Environment: Windows 2000/2003 clusters, SQLserver2000, OLTP, Trading applications, DB2 LUW, Terabytes data, Oracle 9i

IBM, Cupertino, CA Oct. 05 - Feb. 06

Senior DBA

●Supported IBM's Application on Demand Client databases running on AIX, LINUX and Sun Solaris.

●Installed DB2 UDB and created instances.

●Work with SAP Basis team in installing and configuring DB2 UDB and SAP on AIX boxes.

●Perform backup and restore of databases.

●Participate in database upgrade from version DB2 UDB 7.1 to DB2 UDB 8.1.

●Write shell scripts to for backups, reorgs and runstats.

●Write standard operating procedures for maintaining the database.

●Deploy applications written in J2EE, Hibernate and accessing DB2 UDB database.

●Monitor the health of database with BMC Patrol (Siebel and Non-SAP Applications) and Realtech Guard (For SAP R/3 Applications on UDB).

●Create Triggers, Stored Procedures and Functions. Copied data from development to production environment for DB2 on distributed platforms.

Environment: DB2 UDB ESE/EEE, WII, Sun Solaris, LINUX, UNIX, AIX, z/OS, Sun Solaris, BMC Patrol, Realtech Guard, SAP.

MATSON NAVIGATION INC, Oakland, CA Feb. 05 - July 05

Database Administrator

●Matson Navigation Inc. is a logistic company based in Oakland and Hawaii and competes with APL.

●Support Production, development and test systems running on Sun Solaris and AIX.

●Configure UDB Database Parameters.

●Support DB2 UDB and Oracle 9i databases running on Linux, Sun Solaris and AIX for VINsight modules.

●Utilize Tivoli Storage Manager for Disaster Recovery and backup strategy.

●Designed Star Schema for Data Warehouse Project.

●Worked with Application Architect and Developers for capacity planning and design of the new Data Warehouse on distributed environment.

●Maintained ETL jobs for Several DataMart.

●Install Brio query and schedule jobs on Brio Server.

●Troubleshoot Performance and scheduling problems.

●As Brio Administrator (added responsibility), coordinate Brio upgrade from 6.6.1.7 to 6.6.4.

●Monitor Ad-Hoc Queries running on servers and monitor performance levels.

●Work with developers in tuning SQL. Recommended Bufferpool tuning and execute them.

●Utilize ERWIN for maintaining data model for Enterprise Architecture.

●Perform Reverse Engineering and Forward Engineering and generate logical scripts for data model.

●Ensure Production Database availability in a 24x7x365 environment as being on call person for pager support.

●Configured WebSphere Information Integrator v 8.1 and MQ Series for Creating Subscriptions for replication of data from DB2 (legacy system) to DB2 UDB on Sun Solaris. Create shell scripts for backup to be run on these boxes. Migrated databases from Production to Test environment to support development activities.

Environment: DB2 UDB 8.1/8.2, UDB ESE/EE/EEE, MQ Series, Brio (Hyperion Intelligence), ERWIN, AIX, Linux, Sun Solaris, LINUX, SNAPSHOT, EXPLAIN, Oracle 9i, SQL/PLUS, TSM.

EVANT INC (MANHATTAN ASSOCIATES), San Francisco, CA July 04 - Dec. 04

Database Administrator

●Evant Inc. is a Supply Chain software company and competes with SAP in its niche market of Merchandise Planning and Demand Planning and Replenishment.

●Support Production systems running on AIX and Linux for its clients (namely Tweeter and Lillian & Vernon).

●Installed DB2 UDB v 8.1 and v 8.2 EE/EEE/ESE/WSE (Base version and FixPaks) and configured them.

●Coordinate installation of DB2 on Linux, AIX and LINUX boxes with UNIX Administrators.

●Supported PeopleSoft Financial and PeopleSoft HCM modules as part of Production Support for its clients on DB2 UDB and Oracle.

●Export Oracle databases from Production and import into test databases.

●Utilize ERWIN for coordinating the data structure related changes.

●Generate logical scripts for data model for EM3 project and Vendor Module.

●Utilize TOAD and OEM for DB monitoring. Accomplished significant improvement in application performance using EXPLAIN Reports and Visual Explain.

●Ensure Production Database availability in a 24x7x365 environment as being on call person for pager support.

●Create shell scripts for utilities to be run on these boxes (including RUNSTATS and REORG).

●Monitor critical jobs using Process Monitor and schedule them using Process Scheduler.

●Perform recovery and backup operation. Close interaction with DBA teams in US, India, ORACLE and IBM technical support.

●Maintain DPROP (replication) activities and troubleshoot problems.

Environment: DB2 UDB 8.1/8.2, PeopleSoft HCM, PeopleSoft Financials, UDB, ESE/EE/EEE, ERWIN, Process Scheduler, Process Monitor, SQR, RS 6000, AIX, UNIX, LINUX, Quest Central, Quest Spotlight, TOAD, SNAPSHOT, EXPLAIN, Oracle 9i, Quest Central, Quest Spotlight.

State Compensation Insurance Fund, San Francisco, CA July 02 - May 04

Database Administrator

●Maintained databases with DB2 UDB on z/OS.

●Utilized OEM, Quest Spotlight, BMC Change Manager and Catalog Manager.

●Prepare database recovery and shutdown procedures for daily and weekly backups.

●Support PeopleSoft HCM 8.0 and PeopleSoft CRM 8.4 on DB2. Perform upgrades to PeopleSoft HCM 8.8 and PeopleSoft CRM 8.8 and apply patches on Oracle 9i.

●Utilize PeopleSoft Internet Architecture, SQR and Process Scheduler and Upgrade Assistant.

●Create and participate in disaster recovery plan.

●Maintain Roles and Permission Lists for users.

●Monitor application performance using Quest Spotlight, Quest Central, DB2PM, OMEGAMON, Detector and Explain. Used Erwin for logical database design. Perform recovery and backup operation.

MCI WorldCom (Verizon Wireless), Colorado Springs, CO April 96 - May 02

Database Administrator

●Supported CORE, COMS and NetPro applications running on DB2 on OS390 and z/OS.

●Utilized SQR, SQC, Process Scheduler, Application Designer and Crystal Reports.

●Tuned queries with the help of Explain reports.

●Maintained database using Oracle on AIX, UNIX, DB2 UDB on OS390 and AIX.

●Coordinated with Development team on design of tables and table spaces.

●Prepared detailed plan for production and test environment database sizes.

●Monitored database growth. Recommendations on resource utilization.

●Prepared database recovery and shutdown procedures for daily and weekly backups.

●Supported version upgrade from Oracle 7 to Oracle 8i, DB2 v5.1 to v6.1 and DB2 UDB v6.1 to v7.1.

Environment: OEM, LINUX, UNIX, TOAD, IBM ES 9000, RS 6000, AS/400, PeopleSoft, AIX, DB2 UDB, Windows NT, COBOL, OS/390, HTML, Stored Procedures, CICS, JCL, REXX, DB2 Connect, VSAM, AIX, NATURAL, ADABAS, Platinum, Endeavor, ER-Win, OMEGAMON, SPUFI, QMF.

OTHER POSITIONS:

●Adjunct Instructor: Colorado Technical University (Computer Science Department): 01/01-09/01: Enunciate Database Fundamentals (MIS 230) to undergraduates. Utilized Access for the exercises.

●Programmer Analyst; Edison International, Covina, CA 11/95-04/96

●Senior Officer: Tata Iron and Steel Company, Dec 92- Nov 1995. TATA STEEL is owned by TATA Group which produces 3% of India’s GDP and also owns the LandRover and Jaguar brands.

Contact this candidate