Sql Server Customer Service
Resume:
******.*****@*****.***
Sri Sharma
Professional Summary
•8 years of experience with the 32bit, 64-bit Microsoft SQL Server in Production, Development and Testing in Clustered and Stand-alone Server Environments.
•Experience in installing MS SQL Server 2000/ 2005/ 2008/ 2008R2/2012/2014 and updating with hot fix and service packs
•Administered multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
•Extensive experience in implementing high availability solutions on physical and virtual machines
•Implemented Side-by-Side Migration and in-place Upgrade of MS SQL Server 2000/2005/2008 to 2008 R2/2012/2014.
•Experience in using the DMVS, DMFS, SYSTEM VIEWS and in-built Global variables for the instant analysis.
•Worked on High Availability 2012 Solutions Always On.
•Expert in Data Integrity, Performance Tuning and Query Optimization.
•Expert level skills in creating objects like Tables, Views, Normalization, Indexes, Stored Procedures, Cursors, Triggers and other SQL joins and query writing using T- SQL statements
•Performed BCP, BULK INSERT, imported and exported data from different Data Sources.
•Experience in Database design, Performance Analysis and Production Support for very large (VLDB) and Complex Databases
•Handling Memory configurations for SQL Server 2000 and 2005 on Windows 2003/2008 Server
•Experience in analyzing Locks, Dead Locks and handling the Isolation Levels and Concurrency Effects.
•Extensively used the native tools like index tuning wizard, database tuning advisor, SQL Server Profiler, Performance Monitor, Activity Monitor, and Event viewer for performance analysis
•Experience in Backing up, restoring the database manually and also by scheduling the jobs and Maintenance Plans
•Configured SMTP Server for Database Mail setup and received alerts for the Threshold values.
•Experience in Migrating DTS 2000 packages to SSIS packages in 2005 using Migration Wizard
•Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
•Auditing of database for Worked on logins, user permissions and security in SQL server level and fixing orphaned users.
•Thorough understanding of different RAID levels implementation.
•Experience in SQL Programming, logical and physical data modeling of the database in ERWIN and MSVISIO, Normalization, DE normalization, Database design, Performance analysis and production support for very large (VLDB) in OLTP,OLAP Database.
•Strong ability in Scheduling and deploying reports on Report manager.
•Strong experience in mentoring and working with team, coordinating with developers, good communication skills documentation, supporting architects, decision support meetings and 24/7 on call production support.
Education: Bachelor's in Information Technology from Anna University, Chennai, India.
Technical Expertise:
Databases: MS SQL Server 2012/2008R2/2008/2005/2000 & 7.0, oracle8i/9i/10g/11g.
Programming: Visual Basic 6, Visual Basic 5, C, C++, JAVA, .NET & SQL
Operating System: Windows 2008 R2/2003/2000 Advanced Server, NT & Windows 9x, Linux
Other Software: Active X, IIS, Microsoft Transaction Server, VBScripts, HTML, XML
Tools: SQL DB Access, Performance Monitor, Backup Utility, SQL Lite Speed, Visio 2000, Red Gate, Fog Lite, MOM, SCOM
Network Topologies TCP/IP, DNS, WINS, DHCP, FTP, SNMP, SMTP
Certifications
•Microsoft Certified Technology Specialist (MCTS), SQL Server 2008.
NCR Corporation, Aliso Viejo, CA Mar ‘15 – Till Date
SQL Server DBA
•Responsibilities:
•Managed and administrated SQL Server 2012/2008R2/2008/2005 on production and non-production servers.
•Worked on Migration of Sybase databases to SQL Server 2012.
•Implemented and maintained Transactional and Snapshot Replication as Disaster Recovery solution.
•Worked on logins, user permissions and security in SQL server level.
•Setup and maintained Linked Servers.
•Created and managed schema objects such as tables, views, stored procedures, and triggers and maintained referential Integrity.
•Performed various data transfers between various servers using BCP and Import/Export wizard.
•Day-to-day activities like taking backups, restoring the databases, custom code deployment.
•Upgraded SQL server from SQL 2008 to 2014 using inplace and side by side migration techniques.
•Supported technical teams involved with MS SQL issues and operations.
•Provided 24X7 on call support for production systems.
Environment: MS SQL Server 2005,2008 R2,2012 Windows 2003 Server, Windows 2008 R2 Server, Windows 2012 Server, Excel
AMGEN Newburrypark, CA Nov ‘12 – Dec ‘14
SQL DBA
•Responsibilities:
•Installed stand-alone and clustered SQL Server 2008, 2008 R2 and 2012 on 64 bit systems.
•Migrated SQL Server 2005 databases to SQL Server 2008 R2/2012 databases including SSIS packages
•Worked with storage engineers on the RAID 1+0 and RAID 5 disk layouts.
•Performed in-place upgrade from SQL Server 2008 to 2008 R2.
•Configured HADR Always ON on SQL Server 2012.
•Implemented and supported database security regulations, policies, and guidelines.
•Implemented and maintained Database Mirroring, Log shipping and Transactional Replication as Disaster Recovery solution.
•Developed a SSIS package to load data from SQL Base to SQL Server 2008 R2
•Performed Failover drill tests to check the High Availability during disasters
•Used Lite Speed for backups and maintenance jobs which includes updating statistics, database integrity checks
•Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
•Developed and created the new database objects including tables, views, index, stored procedures, functions, triggers, advanced queries and also updated statistics
•Modified Stored Procedures and complex T-SQL queries to improve query execution process
•Created Logins, Roles and Proxy accounts with appropriate permissions and maintaining Database Maintenance Plans
•Configured DB mail by creating accounts and profiles.
•Worked on Linked servers.
•Monitored alerts using Fog Light and Spotlight and also looked into Event Viewer, SQL Error logs and Log File Viewer for software and hardware related errors.
•Provided On call Production support.
•Implemented partitioning on large table to get the performance.
•Tuned stored procedures by using execution plans.
•Performance analysis and production support for very large (VLDB) in OLTP,OLAP Database
•Used table hints in the queries to avoid locks in the server.
•Created missing indexes on the tables by running Data Base Engine Tuning Adviser.
•Finding and solving locks and Deadlocks by using DMV’s and DBCC commands.
•Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries.
•Used Bulk insert to load huge tables.
Environment: MS SQL Server 2005,2008 R2,2012 Windows 2003 Server, Windows 2008 R2 Server, Oracle 11g, ERWIN, MS Visual Studio 2010, Excel, HTML,JIRA 4.3.
L.A. Care Health Plan, Los Angeles, CA August ‘11 – Sep ‘12
SQL DBA
Care Health Plan is an independent local public agency created by the State of California to provide health coverage to low-income Los Angeles County residents. With more than 1.4 million members in seven product lines, L.A. Care is the nation’s largest publicly operated health plan.
Responsibilities:
•Installed SQL Server on both 64 & 32 bit systems
•Managed and administrated SQL Server 2008R2/2008/2005/2000 on production and non-production servers
•Installed SQL Server 2008/05 and service packs on Windows Server Clustered environment
•Migrated SQL Server 2005/2000 databases to SQL Server 2008 databases including DTS to SSIS packages
•Involved in creation of OLAP cubes with SSAS based on multidimensional database.
•Updated statistics, performed database integrity checks and Backup operations
•Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment
•Set up and monitored transactional replication, database mirroring on Production, QA and Dev servers and troubleshot errors.
•Developed and created the new database objects including tables, views, index, stored procedures, functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
•Worked in setting up the SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options
•Configured SQL Server and SSRS using IIS
•Experience in using ERWIN tool for designing the reporting databases
•Responsible to monitor and troubleshooting Log Shipping
•Assisted on the Adhoc-Query requests based on the requirement by using joins, sub queries and co-related sub queries
•Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks
•Created SSIS packages to load robust data from different heterogeneous data sources like Oracle, DB2 to SQL server
•Created, scheduled database maintenance plan using SSIS Maintenance plan task
•Used Online Indexing and online Restoring in SQL 2005
•Extensively used Repositories like Team Foundation Server (TFS).
•Prepared, maintained and modified SQL server installation and configuration documents.
Environment: SQL Server 2000/2005/2008, Oracle 10g, SSIS/SSAS, DTS, C#, .NET, Web Services, JavaScript.
Vantage Bank, Albertville, AL Oct’10 - July’11
SQL DBA
Vantage Bank is a full-service bank with a focus on customer service. So, Vantage Bank is here for the long term with a strategic plan designed to create value for all of our customers. Having conservative management with all decisions made locally, Vantage Bank can provide our customer with a financial partner for life.
Responsibilities:
•Installation of SQL Server 2008/2005, service packs, hot fixes, security patches, Lite speed
•Implemented and maintained Database mirroring as a Disaster Recovery Solution
•Worked on the migration of SQL Server 2000 to SQL Server 2005
•Used Data Partitioning, Snapshot Isolation in SQL Server 2005
•Update statistics, database integrity check and Backup operations
•Generated reports from Jobs, Alerts, SQL Mail Agent and scheduling DTS and SSIS, SSRS Packages
•Designed and implemented comprehensive Backup plan and disaster recovery model
•Worked extensively in Query Analyzer and Profiler for tuning queries using variable for characteristics and query costs
•Created and modified Stored Procedures and Functions to generate reports
•Used log shipping for synchronization of database
•Implemented AWE /PAE switches for SQL Server to grab more than 4 GB RAM
•Configuring Perfmon, blocking analysis, enabling of AWE and PAE, Max degree Parallelism
•Practical experience in managing the internal and external MS SQL database security.
•Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
•Responsible for creating user groups and assigning permissions.
•Optimized stored procedures and indexed query using Index Tuning Wizard.
•Worked on database Design and Architecture based on business user requirements and performed Normalization (Third Normal Form) and De-Normalization.
•Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
•Expert in data transformation services like SSIS, DTS, BCP and Bulk Insert.
•Familiar with taking backup of Regex with Akeeba Backup Tool.
•Involved in validating credit card number using regular expressions.
•Provided back-end support for functional testing and performance testing.
Environment: MS SQL Server 2000/2005 ETL, DTS, SSIS, Oracle 10g, Windows 2003 Server, ERWIN, MS Access, Toad, Excel.
Capital IQ, Hyderabad, India (Offshore) July ‘08 – August’10
SQL DBA/Developer
Capital IQ serves more than 4,200 clients, including investment banks, investment management firms, private equity firms, universities, consultants, and corporations. Components of Capital IQ’s offering include data on public companies, private companies, auditable company financials, M&A/financing transactions, public offerings, corporate executives and board directors, compensation, news, filings, screening tools, chart builder, Excel Plug-In modeling tool, real-time market data and news, relationship tree, macroeconomic data and investment research.
Responsibilities:
•Involved in full life cycle design and development of Data warehouse.
•Experienced in T-SQL development, documenting, coding, modifying and implementing business technology solutions using MS SQL Server.
•Good knowledge in normalization and relational database management systems.
•Developed Complex Queries, Joins and Sub queries in SQL Server 2005.
•Actively participated in gathering of User Requirement and System Specification.
•Dropped and recreated the indexes on tables for performance improvements.
•Used Stored procedures, Inline and Multi statement Functions extensively.
•Imported Data from text files and Excel into SQL Server 2005 database using SSIS/DTS package.
•Bulk insert from one table to another across database using SSIS Packages.
•Performed data type conversion while importing data from another sources (DB2, Microsoft Access).
•Created Data Models and Data Mining in SQL Server.
•Export or Import data from other data sources like flat files using Import/Export of DTS.
•Generated Report Models using Model Designer, to enable the business users to build ad-hoc reports using Report Builder.
•Developed ETL application using SSIS packages to get data from different sources and load into SQL server database and also to send the file into different format from SQL Server Database.
•Developed Drill-through and Drill-down reports using MS SQL Server Reporting Services (SSRS).
Environment: Erwin, XML, T-SQL, SQL Server2000/2005, VisualStudio.NET IDE, Oracle 9i, Microsoft Access 2003, Business Intelligence Tools (SSRS, SSIS, SSAS).
Capital IQ, Hyderabad, India August‘06- June ‘08
SQL Server Developer
Capital IQ serves more than 4,200 clients, including investment banks, investment management firms, private equity firms, universities, consultants, and corporations.
Responsibilities:
•Created Database tables with constraints and relationships between multiple tables.
•Created Views, User Defined Functions and Triggers.
•Extensively used the VB coding and HTML usage.
•Extensively used Joins and sub-Queries to simplify complex queries involving multiple tables.
•Administered the MS SQL Server by creating user logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
•Responsible for creating Stored Procedures and Scheduled to run them by creating SQL Agent Jobs.
•Performed various data transfers between various servers using BCP and DTS.
•Supported team in resolving in DTS and T-SQL related issues.
•Involved in performance tuning and query optimization.
•Performed Database and Performance testing for the database objects.
•Created backup/restore and disaster recovery plans for production servers.
•Backing and Restoring of Databases on Scheduled basis.
•Involved in documenting the entire technical process.
•Involved in the maintenance of the database.
Environment: SQL Server 2000, Oracle 8i, VB 6.0, Windows 2000, Erwin, IIS 5.0, Crystal Reports 9.0 and Microsoft Reporting services 2.0
Contact this candidate