Sql Resume
Dublin, OhiO
SUMMARY
Over 6+ years expertise as DBA in Microsoft SQL Server 7.0/2000/2005/ 2008/200R2/2012 management and performance tuning, System analysis, Design, deployment, and experience on development and testing ETL.
- Migration/Upgrade-Build of SQL SERVER 2012 servers both (Availability Groups (AG) and Failover clustering), Build-Multi subnet Clustering, Broader storage Type support, Predictable Recovery Time and Flexible Failover policy.
- Expertise in Troubleshooting, Installation, configuration, Backup /recovery, database security, Data Transformation Services (DTS), Database design, query optimization, Security administration, Replication(Distributed Data Administration), mirroring, log shipping and clustering
- Experience with Storage Area Networks (SAN) and utilizingSANdisk space in a Windows Environment-Recommendation on LUNS, RAID levels, spindles, SAN Testing-SQL IO, SQLIO SIM.
- Familiar with Virtualization technology and running Windows inside a Virtual Machine
- Experience in transitional replication both configuration and troubleshooting.
- Experience in overhauling improperly designed database schemas including improperly merged entities, improper references between entities, references on the many-side entity failing to reference the full unique key of the one-side entity, and first & second normal form violations.
- Experience with ETL processes for importing vendor data for e-commerce products, assimilating bulk job postings, SHRM member loads and re-loads, and integrating corporate acquisitions\' entire databases.
- Experience in disaster recovery, performance tuning, and migration from 2000 to 2005 and 2008
- Expertise in configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
- Experience in installing MS SQL multiple instances in windows cluster environment.
- Monitoring: Disk space, log space, publishers latency, waits, index fragmentation and generating all the reports
- BI-Provided full life-cycle support and development of BI solutions from requirements to go-live support.
- BI-Provided cross-training and knowledge transfer to other BI Team members and business users.
- Troubleshoot issues reported by users, interfacing with Microsoft and IT helpdesk teams as appropriate.
- Ability to work with server and network administration teams to troubleshoot/ implement changes in a highly-managed and secure network environment
- Work hours outside of office standard business hours may be required to perform system maintenance during scheduled change windows or to troubleshoot any technical or performance issues for after-hour high-severity tickets.
- Defining and/or executing maintenance, administration and configuration tasks for the Biz Talk Platform.
- Experience in installing multiple instances of SQL failover cluster on SQL 2005 & 2008
- Extensive expertise in implementing High availability: Mirroring, Log shipping and Replication.
- Implemented different types of replication models: Snapshot, Merge and Transactional.
- Capacity planning, Performance tuning, Disaster recovery, trouble shooting backup /restore procedures
- Experience in handling in large (VLDB) including T-SQL coding, Full-text indexing, stored procedures.
- Data modeling tools: SQL Diagram, Erwin and Database security with SOX Compliance Standards.
- BI-Expertise in using ETL tools DTS and SSIS, Batch processes, Import, Export, Backup
- Experience with SSIS (SQL Server Integration Services), SSRS (SQL Server Reporting Services) and SSAS
- Developed reports using Crystal reports 9i and SQL Server Reporting Services (SSRS).
Skill Acquired:
Operating Systems: Windows (2000/2003/2008, 2008R2, Data Center edition, NT),
Languages: T-SQL, XML, HTML.
Databases: MS SQL Server 2000, 2005, 2008, 2008R2, 2012, SQL AZURE MS-Access
Tools DTS, SQL Server Integrated Services, Enterprise Manager, SQL Server Management Studio, SQL profiler, Database Tuning Advisor, SQL Backup (Red gate), SQL safe, SQL compare, SQL Diagnostic Manager, light speed, Ignite-Confio, HP Asset Manager and Service Manager, SSIS, SSRS,SSAS, NetApp, Tivoli Backups, Clarfiy, Quest Spot Light.
Related Skills: Visual Source Safe, Rational Clear case, IBM TIVOLI, ESM, Microsoft Visio studio, MS SQL Reporting Services, Integration Services
Audit : Sarbanes Oxley, SOC/SAS 70
SAN: Storage and Storage Area Networks (SANs) including EMC, Fusion-IO, HP, IBM, NetApp, Dell
Server Hardware: Dell, HP, IBM both blades and rack-mount servers
SQL Server, Clustering, Database Mirroring, Log shipping, T-SQL, SQL Agent, Database administration, High Availability, Disaster Recovery| Replication, Profiler, performance tuning, SAN, NAS| disk configuration, NUMA, SSRS, Reporting Services, DTS, Power shell,, Enterprise applications, Infrastructure, Elite Enterprise, ERP software, upgrades, migrations, Project planning,SSRS|SSIS|SSAS|SAN-RAID|
Confidential,
SR.SQL SERVER DBA
Oct 2012-Dec2012
Responsible to the Lead the Migration/ Upgrade Path for SQL Server 2012, Implemented Availability Groups (AG)
- Building the standalone SQL Server 2012 for Availability Groups on Windows server failover clustering (WSFC).
- Configuring Availability Modes, Failover and Failover Modes, Active Secondaries: Backup on Secondary, Active Secondaries: Readable Secondary, Availability Group Listeners, Client connections.
- WSFC Quorum Modes and voting configuration(SQL Server)
Confidential,
SR. SQL SERVER DBA
February 2012-Sep 2012
Dublin OHIO
Environment Details: 4342 Databases which are on 518 Instances with a total of 412 Physical servers Responsible to the Lead the Migration/ Upgrade Path for SQL Server 2012, Implemented both AlwaysOn Solutions which are Availability Groups (AG) and Failover Cluster Instances (FCI)
- SQL SERVER 2012-FCI-Migrated from SQL Server 2008 R2 stretched V-LAN to Multi-Subnet Clustering (Both Build and Design)- Implemented best practices like selection of Quorum Mode, Tune WSFC heartbeat, SAN Replication level and mode and DNS & Client Connections on SQL Server 2012.
- SQL SERVER 2012-FCI- Design and Build the broader storage type support- SMB support, TempDB on Local Disk, Better Mount point support and also configure Predictable Recovery Time and Flexible Failover Policy - Configuring Indirect checkpoints, Health check Time out, Failure condition level.
- Implemented Summation Enterprise (SQL Server based summation) on a 2 node cluster with Dell R810 and MD3200 SAS storage
- Led the migration of the firm\'s mission critical legal ERP system to a remote data center on Dell R810 hardware with MD3200 SAS storage
- Execute several other migrations of mission critical applications using the "Rolling upgrades with Database mirroring" technique.
- Implemented SQL Server installations, upgrades, installation of service packs, hot fixes, and maintenance activities.
- 4th generation SQL Server infrastructure (4 node clustered, multiple named instances) running in a Highly Available data center on Dell R710 hardware with Netapp backend SAN storage using iSCSI interconnects
- NetApp SAN- Sizing server I/O for SQL SERVER 2005/2008 on TR-3779
- NetApp SAN- Designed the storage layout for SQL SERVER 2005/2008 TR-3696
- Database Platform Management responsibilities: responsible for major availability, performance, usage and configuration. Set up, troubleshoots and tunes complex standard and non-standard replication. Created and maintained database policies, standards, and overall documentation including replication, backup, recovery policy, service level agreement, baseline architecture, change management, aces to production, unsupported HW/SW, security & audit violations and risk acceptance.
- BI-supported and maintenance of all BI components and the SharePoint backend on the BI farm including central administration tasks, regular maintenance, administration-level support, and release management. In addition, the administrator will be responsible with end to end solutions, including design, data modeling, ETL, data scrubbing, loading, and reporting, and building dashboards working with the business and power users to develop the solution.
- BI- supported and maintenance on SharePoint farms running SharePoint Server 2010 Enterprise with the beginning the initial implementation of Business Intelligence with the Microsoft BI stack.
- Established security and replication procedures and to Demonstrates expert understanding of database performance tuning, data backup, recovery and security processes/ procedures
- Designed and implemented Upgrade process (migration) from SQL SERVER 2000/2005 to SQL SERVER 2008R2 which has been coordinated by SAN team and Database teams.
- Performance Tuning: Optimize server through wait stats: Like fixing and reducing parallel Execution, Multi-Tasking Waits, IO waits, Backup and Restore Waits, Locking Waits, Database Log Waits, Waits on External Resources.
- Mentored Team of Three Jr. SQL SERVER DBAs
- SQL Azure: calculate Overall cost by SKU in dollars, Bandwidth cost by direction and type, Calculate the estimated cost for each database, find the size of each database-broken down by object,
- Worked with Linux team to have Microsoft SQL Server ODBC Driver 1.0 provides robust data access to Microsoft SQL Server.
- Developed long-term and short term goals for production databases and for application teams
- Worked with application team to create and enhance coding standards, quality assurance policies and database architectures.
SQL SERVER DBA
December 2011-Feburary2012
Confidential,
Responsible for 159 production servers, 220 Quality assurances (QA), 110 Demo, 440 Test servers where I worked up to 1.4 TB database (single database)
- Wrote automated backup and highly configurable index /statistics maintenance stored procedures for both the DEV an client production sites in a VLDB environment
- Performance Tuning on both Instance level(Server Level) and Database Level (Query Tuning)
- Server level: Optimizing Memory usage both Buffer pool (Plan cache and Data Cache) with Kernel level allocation.
- CPU Tuning: Heavy resource intensive queries optimization as well as optimizing System cache(L1, L2, L3)
- Review and analyze system logs to preemptively detect and correct system issues. Monitor usage including load and usability issues.
- Perform capacity planning to ensure adequate availability and performance. Manage and test disaster recovery strategies
- Automated bugs/white list apply in all Prod/Sandbox and Pre-Prod environment
- NetApp- Implemented Microsoft SQL Server 2008: Decision support workloads-1 TB Data warehouse on IA64
- Setting up Log shipping & Replication(Transitional) on Production environment
- Individually implemented Transactional Replication process (push) for updating 180 subscribers with 100 publishers.
- Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures
- Create models for new database development and/or changes to existing ones
- Respond to and resolve database access and performance issues
- Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements
- Installed MS SQL Server2000/2005/2008 on Windows 2003/2008 servers, applied service packs, security fixes
- Resolve database performance issues, database capacity issues.
- Develop database procedures, triggers and SQL scripts for development teams.
- Created Scheduled jobs to execute multiple DTS package to extract data from multiple Rockwell and Avaya switches from the southeast regions call centers.
- Involved in setup of the clustered SQL server environment at VLDB.
- Performed performance and scalability testing using NetApp FAS920 storage systems.
- Designed the Architecture and components, workload sizing guidelines, Approximate data sixes and Building Growth-capacity models on FAS920.
Confidential,
SQL SERVER DBA
May2011-November2011
Responsible for 38 production servers, 34 Quality assurances (QA), 5 Demo, 20 Test servers
Responsibilities:
- Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
- Clustering: Troubleshooting on both SQL Server and windows level clustering
- Designed and developed SQL Server Integration Services (SSIS) for data migration.
- Implemented database maintenance plan for new SQL server 2005 databases.
- Implemented data partitioning for new SQL Server 2005 databases (Created partition function, partition scheme mapped to a partition function and created the table on the partition scheme)
- Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
- Implemented and configured IIS services , 6.0 and 7.0
- Net App database storage Designs: separate TEMPDB, separate Transaction Log, Multiple File Groups, Table Partitions.
- BI-Interfaces with end-users and power users across multiple regions for BI development and support. Work with various IT functional areas, including development, infrastructure, project management, and transition teams as necessary for projects and releases. Work with product leads for technology planning and management
- PowerShell-Implemented windows management instrumentation task(WMI) like Browsing the WIN32 WMI classes, checking Disk space, checking what services are running on a server, IS IIS Running on your SQL Server.
- PowerShell- implemented Browsing the SMO classes, List the members of the sysadmin role on a server, List the local administrators on a server, find a login or AD group on Multiple servers, check for failed SQL Ages jobs on multiple servers and Miscellaneous Tasks like Finding a port number, generate a random password, etc.
- Set up and schedule jobs that perform backups and database structure checks
- Monitored MS SQL servers for errors and performance degradation.
- Performed all aspect of database administration, including backup, recovery, and replication for SQL server 2005.
- As part of a team, analyzed the business requirements and systematically designed a database. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using SSIS
- BI-SSRS-configured the report server Databases, SharePoint integration, working with Report server Encryption keys, Initializing the report server instance, configuring E-mail and execution account.
- BI-SSRS-used Reporting services administration tools like Report manager and command line.
- BI-SSRS-Administering Reporting services site settings-configuring-Reporting services site name, My reports feature, report history, report execution timeout, report execution logging.
- BI-SSRS-Reporting services security-Administering Item roles, system roles
- BI-SSRS-Administering shared data sources and reports like-creating a shared data source, configuring shared data source credentials, securing the shared data source, publishing and viewing Reports, viewing and changing the report data source, viewing and changing report properties, administering a report-specific data source and creating linked reports with troubleshooting reporting services.
Confidential,
Secaucus New Jersey
Feburary2011- May2011
SQL SERVER DBA
Responsibilities:
- Solved two critical performance issues in aggregate T-SQL queries that caused the data load for Encounter Pro and Pend Analyzer to monopolize the CPU on the SQL Server for many hours.
- Optimized the database and application performance of the IC-Chart electronic health records system addressing poorly written queries, missing or poorly designed indexes, and excessive ADO web-DB round-trips.
- Wrote ad-hoc queries and stored procedures for numerous ad-hoc and production reports utilizing heavy-duty T-SQL aggregate queries with many joins and derived tables.
- As part of a team, analyzed the business requirements and systematically designed a database. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using SSIS.
- NetApp-Used Aggregate to manage the Raid-Protected storage used Snap Drive for windows software integrates with windows volume manager so that storage systems can server as storage devices for application.
- Net App-Configured Partition View, Flex Volume to couple user data, meta data and snapshot copies that is loosely coupled to its containing aggregate.
- Supported in Deploying Network Load Balance, configuring the NLB NIC and installing.
- Installed new MS SQL Server 2005 and maintained 10 servers (Total size of the db around 5.1 TB).
- Implemented SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
- Designed the entire logical and physical model with 100 + tables using Visio, ERWin
- Enforced referential integrity via creation of constraints on database objects
- Designed and developed SQL Server Integration Services (SSIS) for data migration.
- Implemented database maintenance plan for new SQL server 2005 databases.
- Implemented data partitioning for new SQL Server 2005 databases (Created partition function, partition scheme mapped to a partition function and created the table on the partition scheme)
- upgrade planning from SQL server 2000 to SQL server 2005
Confidential,
SQL SERVER DBA
April2010-Janurary2011
Responsible for daily maintains issues, taking care of ticketing system, release management process, monitoring the productions servers
- Set up alerts, operators, SQL Mail, SQL Agent Mail, and notifications.
- Implemented and configured IIS services , 6.0 and 7.0
- Implemented windows management instrumentation task(WMI) like Browsing the WIN32 WMI classes, checking Disk space, checking what services are running on a server, IS IIS Running on your SQL Server.
- PowerShell- implemented Browsing the SMO classes, List the members of the sysadmin role on a server, List the local administrators on a server, find a login or AD group on Multiple servers, check for failed SQL Ages jobs on multiple servers and Miscellaneous Tasks like Finding a port number, generate a random password, etc.
- Set up and schedule jobs that perform backups and database structure checks Viewer, etc
- Monitoring SQL server performance using profiler to find performance and deadlocks.
- Designed & implemented comprehensive Backup plan and disaster recovery strategies.
- Monitored and modified Performance using execution plans and Index tuning.
- Working with SQL Server Integration Services in 2005 for moving DTS packages.
- Rebuilding the indexes at regular intervals for better performance
- from backup in disasters
- Analyze long running slow queries & tune the same to optimize application and system performance.
- Writing Stored Procedures / Transact-SQL scripts.
- Creating / Scheduling Jobs, Alerts & Reports (Excel).
- scripts interactively by invoking SQL Query Analyzer
Skills Used: MS SQL Server 2005/2000 with clustering, T-SQL, Win 2003, Oracle 8i, and Visual Basic 6.0 , SQL enterprise manager.
Confidential,
SQL SERVER DBA
Hyderabad India
August2004-August2009
- Performed all aspect of database administration, including backup, recovery, and replication for SQL server 2005.
- As part of a team, analyzed the business requirements and systematically designed a database. Employed best practices in creating a complete schema including tables, relationships, stored procedures, views, clustered and non-clustered indexes and triggers, and implemented the importation and exportation of data using SSIS
- SSRS-configured the report server Databases, SharePoint integration, working with Report server Encryption keys, Initializing the report server instance, configuring E-mail and execution account.
- SSRS-used Reporting services administration tools like Report manager and command line.
- SSRS-Administering Reporting services site settings-configuring-Reporting services site name, My reports feature, report history, report execution timeout, report execution logging.
- SSRS-Reporting services security-Administering Item roles, system roles
- SSRS-Administering shared data sources and reports like-creating a shared data source, configuring shared data source credentials, securing the shared data source, publishing and viewing Reports, viewing and changing the report data source, viewing and changing report properties, administering a report-specific data source and creating linked reports with troubleshooting reporting services.
- Maintained the database consistency with DMV’s/DMF’s at regular intervals
- Analyze some of the long running slow queries & tune the same to optimize application and system performance.