Sr. SQL Server DBA

******.*****@*****.***

PROFESSIONAL SUMMARY

8+ years of IT experience in Database System Analysis, Design, Implementation and Administration of MS SQL Server 2012,2008R2,2008, 2005 in Production, Test, Development and Replication & Cluster Server Environments.

Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008 & R2/2005/2000 on Clustered and Standby Environments.

Expertise in complete Software Development Life Cycle (SDLC) - Analysis, Design, Development, Deployment and Testing.

Expertise in Database Administration on Production Servers with server configuration, performance tuning and maintenance with outstanding troubleshooting capabilities.

Administering SQL Server High Availability and Disaster Recovery strategies.

Worked on logical and physical data base modeling with UML and ERWIN tools.

Excellent knowledge in RDBMS concepts and constructs along with Objects creation such as Database, Table, Normalization, UDF, User Defined Data Type, Indexes, Views, Cursors and Triggers.

Experience in using SQL Server Tools like DTS, Import/Export Wizard, SQL Server Enterprise Manager, SQL Profiler and SQL Query Analyzer.

Master in performing administrative tasks: database files management, backup/restore, Security Management, Database Mirroring, Data Integration and Synchronization.

Hands on experience with T-SQL (DDL, DML, DCL) in Implementing & Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating & Updating tables and checking the database consistency by executing DBCC Commands.

Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2005/2008/2012/2014.

Solid experience on high availability SQL Server solutions, including Replication Models (Snapshot/Transactional) and SQL Server clustering (Active-Active, Active-Passive).

Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.

Experience in designing/generating/using/deploying Visual Studio Business Intelligence Reports, SQL Server Reporting Services (SSRS), and Crystal Reports.

Strong experience in mentoring team members and writing documentation.

24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

Databases : SQL Server 2005/2008/2012/2014, Oracle 11g, 10g, 9i

Languages : T-SQL, PL/SQL, SQL * Plus, SQL*Loader, TOAD

Methodologies : Agile SCRUM, Test-Driven Development

Reporting Tools : SSRS, Cognos 8, Microsoft Clustering Services (MSCS), Crystal Reports

Modelling Tools : SQL Server Analysis Server 2005(SSAS), Red gate

ETL Tools : Microsoft Integration Services (SSIS), Cognos Decision Stream.

Operating Systems : Windows 95/98/NT/XP/Vista, Windows 2007/2008

Web Server : Internet Information Services (IIS)

MS Office Tools : MS-Word, MS-Excel, Power Point, MS Access, VISIO, MS-Publisher, MS-Outlook.

PROFESSIONAL EXPERIENCE

Client: United Airlines, Houston, TX APR 15- Present

Role: Sr.SQL Server DBA

United Airlines, Inc. provides air transportation services in North America, the Asia-Pacific, Europe, the Middle East, Africa, and Latin America. The United IT team designs, develops and maintains massively scaling technology solutions that are brought to life with innovative architectures, data analytics and digital solutions. The database team will be responsible for activities related to the design, development, implementation, and 24x7 production support of United's complex, highly-available Microsoft SQL Server databases. You’ll align with the eCommerce/Self Service and IT Infrastructure portfolios to deliver best-in-class databases to achieve business goals.

Responsibilities:

Worked with a team for data access programming, physical database design, and implementation of Microsoft SQL Server.

Database Analysis of each database which is part of old or unsupported Hardware and software.

Documented and Maintained the database instances across the environment and worked with the procurement to allocate appropriate licensing to all the servers

Engineered and implemented a database design to consolidate number of database instances.

Datacenter Migration with SQL Server upgrades

Worked with a team responsible for the 24x7 support of Microsoft SQL Server databases.

Installed & Configured SQL Server 2016/2014/2012/2008 R2/2008/2005 64/32bit versions on Windows 2012/2008/2003 R2 64/32 bit servers on Enterprise systems. Both on Windows Physical servers and Virtual Servers.

Create logical and Physical data models for various applications

Designed and developed data models for new applications

Upgraded the database from oracle 9i to 10g using DBUA, export/import utilities.

Migrated SQL Server SSIS packages from SQL 2005/2008/2012 to SQL 2008/2012/2014 with effective planning.

Environment:

SQL Server 2005/2008R2 /2012, Windows Enterprise Server 2003, ORACLE 10g, IIS 6.0,UNIX, Erwin, Microsoft Visio 2003,SSRS, SFTP, Oracle RAC,DB2,Microsoft Silver light, Microsoft Reporting Services(SSRS), DB2, Share Point Server, SSIS, DTS, Erwin, Cluster Environments, Red Gate, Spot light, Solaris, SSIS, Oracle Clustered Environments, Oracle Replication environments,ADABAS. TCP/IP, Named pipes, LAN Sockets

Client: NRT LLC, Minneapolis, MN July 14 – April 15

Role: SQL DBA

NRT LLC is the nation’s largest owner and operator of residential real estate brokerages operating in more than 50 of the 100 largest metropolitan areas in the United States. The IT database team is responsible for design, development, delivery and support of stable high performance solutions that meet the business needs. As a part of the team, the developer will be work with fellow designers, developers, testers and product owners daily to meet the goal.

Responsibilities:

Designed and developed Asset tracker application including requirement gathering

Upgraded SQL server 2000/2005/2008/2012 to SQL Server 2012/2008 R2/ 2008/2012/2014/2016 on Operating Systems Windows Server 2003 R2/ 2008 R2/2012

Migrated SQL Server SSIS packages from SQL 2005/2008//2012 to SQL 2008/2012/2014 with effective planning.

Designed different database backup strategies for effective use of space and minimum time to recover when needed.

Strategically invested in tools to minimize the storage costs along with the time taken for running backup jobs.

Automating Database Backups of various user databases per the requirement.

Automated refreshes from production to development database on a regular basis using PowerShell.

Implemented backup and recovery strategy and performed full, incremental and cumulative backup using RMAN.

Involved in Source Data Analysis and designing mappings for data extraction

Developing, deploying, scheduling and troubleshooting for performing data transfers and ETL purposes across different database/file servers using SSIS.

Responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.

Package development using logging capabilities.

Upgraded and redesigned several DTS/SSIS packages from SQL 2000/2005/2008 to 2005/2008/2012/2014

Upgraded and redesigned several SSRS RDL files from SQL 2005/2008 to 2008/2012/2014

Scheduled SSIS Package Jobs and monitored the jobs using SQL Server Agent.

Environment:

SQL 2000, SQL Server 2005, WINDOWS 2000, 2003, SSRS, SSIS, Crystal Reports 10.0, MS Access, RedGate SQL

Client: Verizon, Irving, TX Feb 12-Jun 14

Role: SQL Server DBA

Verizon is a leading communication technology company in the world. Every day, it connects millions of people, companies and communities with the powerful technology. It is using its network to make breakthroughs in interactive entertainment, digital media, the Internet of Things and broadband services for customers.

Responsibilities:

Organized database server system previously managed by non-DBA to support SDLC process and securing to eliminate the vulnerabilities

Designed Disaster recovery process

Designed new security system to organize all the security requirements

Responsible for data integrity, user security, daily monitoring for production and non-production systems.

Involved in various Audit meetings both internal and external auditors.

Designed and automated various Security/Audit reports using the SSRS for auditors.

Database Performance improvements by introducing various techniques

Consolidating database systems.

Upgrade several database servers to the latest versions.

Introduction of MDW to the client.

Technical Consultation for the entire database related items.

Created email alerts with the reports of daily backups, maintenance jobs and security checks.

Documenting the database physical and logical design.

Maintaining the Application data flow from various systems.

Created database snapshots before a deployment to ensure the changes are rolled back without compromising the time of availability in case of errors.

Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment. Performed the Switchover, Switchback and Failure tests of the primary and physical standby and verified the successful catching up of standby with the primary DB.

Environment:

SQL Server 2000/2005/2008/2008 R2 /2012,.NET,SSRS,SSIS,SSAS, DB2, DTS, Erwin, Cluster Environments, Red Gate,TFS, Spotlight

Client: Epic Systems, Verona, WI Mar 11 – Jan 12

Role: SQL Server DBA

Epic Hospital in Verona is largest community hospital, with 392 beds and a medical staff of more than 400 physicians representing nearly 50 medical and surgical specialties. Recognized for its excellence in heart and vascular care, inpatient and outpatient cancer care and wide ranging surgical specialties, including orthopedic surgery, neurosurgery and minimally invasive surgical procedures, Hospital is also home to the region's busiest emergency department, which treats more than 55,000 patients a year

Responsibilities:

Planned and upgraded data warehousing database instances from SQL 2000 à SQL 2005 which also involved migration of DTS to SSIS packages.

Secured several database servers with limiting the security for several non-DBA maintained database servers.

Modified existing database by adding tables and relationship to existing data model.

Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity and provide additional application functionality.

Maintained the data, database backups and restoration, backup strategies, scheduled backups.

Involved in complete backing up of Database and restored the database from Disaster Recovery.

Involved in testing, bug fixing and documentation for the project.

Environment:

Microsoft SQL Server 2000/2005/2008/2008R2/2012, SharePoint, SSIS, CDC, SSRS, SSAS, Erwin, TFS, Visual Studio

Client: Elantecs, Hyderabad, India Nov 2008 – Aug 2010

Role: Database Admin - Intern

Key Accomplishments:

Upgrade SQL 2000 to SQL 2005

Day to Day DBA tasks

Created user defined data types and added them to model database for future purpose.

Worked on Authoring Reports and managing reporting services.

Logical and physical database design using Erwin Tool.

Performing query plans and making sure each query is using appropriate indexes.

Environment:

SQL Server 2000/2005 Enterprise Edition, SQL, T-SQL, XML, MS PowerPoint, MS Project & Windows 2003 server, Visual Studio 2005

EDUCATION

Master of Science

International Technology University, Fremont, CA Sept 2010 to Dec 2011

Bachelors of Technology, Computer Science Aug 2005 to May 2009

Contact this candidate