Sql Dba Resume
Ashborn, VA
Summary:
- 8+ years of extensive experience in development, analysis, design, implementation, testing, and maintenance with diverse collection of applications andClient Server environments.
- Around 8 years of professional experience in Microsoft SQL serverdatabase administration and development
- Production, Stage and Developmentserver's maintenance related to financial, health care and telecom domain.
- Experience in installing MS SQL SERVER 2000,2005,2008, updating with the hot fix and service packs
- Configured the servers on 32 bit and 64 bitclustered and standalone server environments.
- Good experience on physical storage configuration and optimization of SAN/NAS/DASD with different RAID levels.
- Configured the AWE and /3 GB switch for the 32 bit 2005 server.
- Migration from SQL server 2000 to 2005 and 2000/2005 to 2008R2 by using In-Place/side-by-side upgrade process, And documented the Upgrade Process.
- Expertise in implementing efficient Disaster Recovery Strategies and High availability like Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring.
- Hands on experience with administering large databases, managed databases of size above 2 terabytes, database design, normalization and database application development using varied development tools.
- Good at SQL Server 2008 enhanced features like activity monitor, Multi Server Query, Policy Based Management, data compression, resource governor, performance data collector, facets, and transparent data encryption.
- Implemented the 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, SQLCMD and dedicated admin connection.
- Additional features like T-SQL debugger, CTE, Secure Sockets Layer,certificates, and symmetric /asymmetric key.
- Expert in writing DDL and DML statements.
- Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
- Hands on experience workingwith analytical and diagnostics reports.
- Expertise on administration,change management processes, performance analysis, production Support for largedatabase.
- Extensively worked Hot, Warm and Cold Backups,Security Management, Managing server and client Connections.
- Ability to detect and troubleshoot SQL Server related CPU, memory bottlenecks, I/O, disk space and other resource contention.
- Experience in analyzing and resolving Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
- Extensively used the native tools like index tuning wizard, data base tuning advisor, profiler, perfmon, activity monitor, Event viewer for performance analysis.
- Experience in administrative activates comprising Performance Tuning, Query Optimization, Client/Server Connectivity, and Database health Check, Indexing, Updating Statistics.
- Intensive experience in monitoring and tuning SQL Server database performance using SQL Profiler, DMV's, Index Tuning Wizard and Windows Performance Monitor.
- Experience in trouble shooting sql server jobs, and job monitoring tool.
- Expertise in using DBCC trace flags, handling blocking and dead lock situations.
- Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
- Explicitly used third party tools like Litespeed, Foglight and Red gate.
- Auditing of database for users transaction, login, and database action and removing/mapping orphan users. And troubleshoot user access issues whether from ODBC clients or .NET SQL Native clients
- Familiar with setup and troubleshoot DTS/SSIS, and Migrated DTS packages into SSIS packages using upgrade advisor tool.
- Used DTS Xchange tool for Migrating DTS packages to SSIS.
- Expertise in performing data transformations between servers using Export/Import, BCP, DTS, SSIS, bulk insert, Copy, Xcopy, and RoboCopy.
- Hands on experience on Analysis Services (SSAS), Reporting Services (SSRS), Integration Services (SSIS).
- Experience in handling Partitioned cubes in SSAS both in star and snow flake schema.
- Experience in creating CUBES in BIDS with Fact and Dimension Tables.
- Good Experience in Siemens Decision Support System Tools
- Implementation of SQL Server Reporting Services added SharePoint Integration Mode (64 bit platform).
- Expertise in SQL Loader and Import/Export Utilities.
- Used Filtered Indexes for improving query performance, lower storage and maintenance cost.
- Expert in implementing Web services using ASPX and executing them from functions or stored procedures in SQL Server.
- Developed and maintained desktop and server applications using VB, VB.Net and C#.
- Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, and triggers.
- Excellent experience with UNIX operating system and Shell scripting.
- Having good experience in configuring and troubleshooting IIS and XML.
- Stored SSIS packages in XML format.
- 24 X 7 Production Database on Call Support.
- Played a key role in business requirements analysis, architecture design, physical and logical Datamodeling, application development, testing, training, production support and Project review with client.
- Maintaining SQL Script for creation of Database Objects using VSS (Visual Source Safe).
- Configuration and Administration of SharePoint 2007 and SharePoint server designer 2007.
Operating Systems:
Windows Vista/XP/2000/NT, Windows Server 2003/2008, Linux, Unix.
Databases:
MS SQL Server 2008R2/2008/2005/2000/7.0, MYSQL, Oracle, MS Office Access 97/2000/2003/2007/2010.
ETL TOOLS:
SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Data Integrator, Data transformation services (DTS)
Database Tools:
SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server
Management Studio.
Data Modeling Tools:
Erwin, Red gate, Light speed.
Languages:
T-SQL, C/C++,C#, java script, Visual Studio2008R2/2008/2005/2003, ASP.NET, VB.Net
Applications:
Microsoft Office Suite, Adobe Photoshop, Acrobat Reader/Writer.
EDUCATION
Bachelor Of Technology in Computer Sciences
Professional Experience
Confidential, Ashborn, VA May2011 TO Till today
SQL DBA
Responsibilities:
- Managed and AdministratedSQL SERVER 2008/2000 highly transitive Production Environment And Active passive clustered environment. Worked to the max database of size 2 TB.
- Migrated databases from SQL Server 2000 to SQL Server 2008 and documented the process with Pre-Migration and Post-Migration steps.
- Handling Memory configurations for SQL Server 2000 and SQL Server 2008 on Windows 2008.
- Implemented the new SQL Server 2008 and 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, CTE, PIVOT, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
- Worked with Distributed Partitioned Views (DPV) for Load balancing between the Servers.
- Configured more than 64 GB ram on 64 bit Environment.
- Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
- Migrated DTS packages to SSIS packages and Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
- Checking Database Health by using DBCC Commands and DMV'S.
- Monitored and modified Performance using execution plans and Index tuning.
- Recovered the System and User databases from suspect mode.
- Expert in sizing and utilizing the Temp database in an efficient way.
- Used log shipping for synchronization of databases.
- Prepared Documentation for the Disaster Recovery plan
- Implemented new topics like CLR integration on Development Server.
- 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
- 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 Semi-Production Servers and handling maintenance Jobs.
- Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
- Did Performance Tuning of the Stored Procedures.
- Routine Developer/DBA jobs like Backups and Restores
- Good experience in data modeling and metadata services.
- Used APPLY clause and also implemented with CROSS and OUTER APPLY to join tables and table variable functions.
- Hands on experience in trouble shooting database issues.
- Update statistics, database integrity check and Backup operations
- Expertise in SQL server Reporting Services(SSRS)
- Good knowledge on GSM
- Worked extensively with XML data type, indexing, schema processing and integration
- Monitoring SQL server performance using profiler to find the performance and dead locks.
- Worked on call 24/7 Support on weekly basis.
- Responsible for managing and improving database performance and stability for the Verizon Business Invoicing system that bills out $130million a month.
- Extensively used Repositories like Team Foundation Server (TFS), Visual source safe and Clear Case for Data Archival.
Environment: SQL Server 2000/2005/2008 with clustering, Replication, T-SQL, Windows 2003 64-bit, BugZilla, DTS, SSIS, RedGate, Profiler, MOM, SQL Sentry, Share point, Sql Server 2008,Oracle 10g,TFS,LiteSpeed.
Confidential, NJ June 2010 TO April 2011
SQL Server DBA
Responsibilities:
- SQL Server 2005 Database Administration.
- Installed and configured more than 2GB RAM in SQL Server 2005.
- To handle the migration of SQL Server 2000 to SQL Server 2005.
- Migrated data from MySql and Oracle on Linux environment to SQL Server 2005 Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
Responsibleto Monitor and troubleshooting Log Shipping. - Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
- Implemented and maintained Database mirroring as a Disaster Recovery Solution.
- Installed, authored, and managed reports using SQL Server 2005 Reporting Services
- Did trouble shooting of Client connections, viewing error log and applications.
- Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
- Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file groupmodifications, and adding scheduled jobs to re-index and update statistics in databases.
- Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
- Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
- Extensively used DDL and DML statements to create objects and modify the data.
- Experience with data retrieval using XML
- Extensively participated in developing front end applications using C# and VB
- Transferred data (ETL) to Data ware house Environment using SSIS.
- Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
- Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
- Expertise in SQL Server Analysis Services.
- Expertise in creating and supporting in OLAP Cubes
- Retrieved data from partition of the Cube from DATA WARE HOUSE(OLAP ) using the BIDS
- Managed VERITAS net backups.
- To analyze long running queries and tune the same to optimize application and system performance.
- Maintaining the database consistency with DBCC at regular intervals.
- Involved in creating and supporting in OLAP Cubes
- Extensive knowledge on CDSS used for medical diagnosis
- Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.
- Experience in logical and physical data modeling of the database in ERWIN and MSVISIO
- Configured SMTP Server for Database Mail setup and received Alerts for the Threshold values.
Environment: TSQL, MS SQL SERVER 2000/2005,SSRS,My SQL, Linux, QUERY ANALYSER, VISUAL STUDIO 2005 ,VB.NET,C#,WINOWS SERVER 2008,IIS,SSIS,SSRS,BI
Confidential, Abbott Park ,IL June 2009 TO May 2010
SQLDBA
Responsibilities:
- Coordinated physical changes and performance monitoring of two replicated production servers, two development servers and one reporting server, all Microsoft SQL Server 2000.
- Migrated databases from SQL Server 2000 to SQL Server 2005 and documented the process with Pre-Migration and Post-Migration steps.
- Configured more than 2 GB ram on 32 bit Environment.
- Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.
- Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
- Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions).
- Experience in using the DMVS, DMFS, SP_PROCS, INFORMATION_SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
- Utilized foglight for monitoring the deadlocks, blockings and windows level performance also.
- Responsible for all database architecture and program design, including survey systems, report developers, OLAP cubes, and interfaces with clients' CRM software.
- Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages.
- Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
- Wrote triggers and stored procedures to integrate 3rd party applications into in-house apps such as project management systems with a minimum of development time, helping the company build new partnerships faster.
- Profiled and tuned servers on a monthly basis to ensure fast queries and reports.
- Trained developers on how to write better SQL, how to use more powerful features like table variables, how to avoid cursors, etc.
- Evaluated OLAP tools, and built web-based OLAP cube reporting systems around it.
- Created web-based dashboard to show reports produced, average report run time, emails sent, surveys taken, etc.
- Wrote, designed and produced customer site allowing customers to view reports, place orders, download newer software versions, and set up their own surveys.
- Created company intranet with help desk ticket and order tracking.
- Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
- Implemented load balanced web servers for high availability.
- Extensively developed different applications using C# in co-ordinance with development team
- Evaluated and purchased reporting systems including Actuate, Case Studio, Visual Studio .NET, Net Charts, and UML diagramming.
- Wrote installation and procedural manuals for support staff.
- Created linked servers between Oracle 10g and MS SQL SERVER 2005 and also deployed SSIS packages for data transfer.
- Good knowledge of Oracle Database 9i/10g Administration and Creating pl/sql packages, procedures and functions.
- Capable of scheduling jobs, backup and restore in Oracle 10g using isqlplus(html mode) Good knowledge in handling file system in UNIX OS.
Environment: SQL Server 2008/05/00, SQL Profiler, T-SQL, SSIS, SSRS, SSAS, VB.Net, C#.Net, ASP.Net, ERWIN, Litespeed, MS-Excel.
Confidential, SC July2008 TO May 2009
SQL Server DBA
Confidential, provides funding and financial services to Agricultural Credit Associations (ACAs) in eastern states. These associations, operating as Farm Credit and Ag Credit associations, provide real estate and production financing to farmers, agribusinesses, and rural homeowners. AgFirst also operates a growing Capital Markets unit that arranges and participates in loans for agribusinesses across the nation, and a Correspondent Lending Market department that buys, sells and services rural home and agricultural loans. AgFirst is governed by a stockholder-elected Board of Directors.
Responsibilities:
- Coordinated physical changes and performance monitoring of two replicated production servers, two development servers and one reporting server, all Microsoft SQL Server 2000.
- Migrated databases from SQL Server 2000 to SQL Server 2005 and documented the process with Pre-Migration and Post-Migration steps.
- Configured more than 2 GB ram on 32 bit Environment.
- Dexterous developer in creating Constraints, Defaults, Rules, Tables, Indexes, Views, Stored Procedures, Functions, Triggers, Cursors and Dynamic sql queries.
- Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
- Configured Security at ACTIVE DIRECTORY and SQL SERVER LEVEL by Creating Principals (logins) and Mapping users to roles. (Securable and Permissions).
- Experience in using the DMVS, DMFS, SP_PROCS, INFORMATION_SCHEMA, and SYSTEM VIEWS AND in built GLOBAL VARIABLES for the instant analysis.
- Utilized foglight for monitoring the deadlocks, blockings and windows level performance also.
- Responsible for all database architecture and program design, including survey systems, report developers, OLAP cubes, and interfaces with clients' CRM software.
- Responsible for backups/restores, monitoring SQL uptime, designing and maintaining DTS packages.
- Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability.
- Wrote triggers and stored procedures to integrate 3rd party applications into in-house apps such as project management systems with a minimum of development time, helping the company build new partnerships faster.
- Profiled and tuned servers on a monthly basis to ensure fast queries and reports.
- Trained developers on how to write better SQL, how to use more powerful features like table variables, how to avoid cursors, etc.
- Evaluated OLAP tools, and built web-based OLAP cube reporting systems around it.
- Created web-based dashboard to show reports produced, average report run time, emails sent, surveys taken, etc.
- Wrote, designed and produced customer site allowing customers to view reports, place orders, download newer software versions, and set up their own surveys.
- Created company intranet with help desk ticket and order tracking.
- Experience in Backing up, restoring the data base manually and by scheduling the jobs and Maintenance Plans.
- Implemented load balanced web servers for high availability.
- Extensively developed different applications using C# in co-ordinance with development team
- Evaluated and purchased reporting systems including Actuate, Case Studio, Visual Studio .NET, Net Charts, and UML diagramming.
- Wrote installation and procedural manuals for support staff.
- Created linked servers between Oracle 10g and MS SQL SERVER 2005 and also deployed SSIS packages for data transfer.
- Good knowledge of Oracle Database 9i/10g Administration and Creating pl/sql packages, procedures and functions.
- Capable of scheduling jobs, backup and restore in Oracle 10g using isqlplus(html mode)
Good knowledge in handling file system in UNIX OS.
Environment: SQL Server 2008/05/00, SQL Profiler, T-SQL, SSIS, SSRS, SSAS, VB.Net, C#.Net, ASP.Net, ERWIN, Litespeed, MS-Excel.
Confidential, Hyderabad, India May 2004 TO June 2008
SQL Server DBA
Confidential, is a state-ownedtelecommunication enterprise in India. BSNL is the fourth largest cellular service provider, with over 63.45 million customers as of March 2010 and the largest land line telephone provider in India.
Responsibilities:
- Installing, configuring, administering and securing production and non-production servers.
- Involved in complete SDLC which includes requirement gathering, analysis, design, development, Implementation.
- Implemented and maintained database security.
- Involved in capacity planning and sizing for new database servers.
- Migrated MS-access databases to SQL Server 2000 databases.
- Extensively worked on Snapshot Replication.
- Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
- Used SQL Server System Tables to retrieve metadata.
- Trouble shooted and minimized production down issues.
- Created T-SQL, PL/SQL packages, procedures, functions, triggers, and alerts, scripts for automation and DTS packages for ETL.
- Developed Transact-SQL scripts to enforce business rules.
- Hands on experience in writing DML statements which are used for managing data within schema objects
- Monitoring of alertlog files, control files, archive logdestinations, blocking, deadlock issues and long running complex queries/stored procedures.
- Export and Import of database objects to copy from one database to another database.
- Designed new job process, new database maintenance plans, DTS packages.
- Monitored failed and long running MS SQL Server jobs.
- Resolved blocking and deadlocks issues with the databases / servers on a real-time basis.
- Used SQL Profiler to monitor the server performance, debugging T-SQL and slow running queries.
- Monitored, tuned and analyzed database performance and allocated server resources to achieve optimum database performance.
- Maintained User account administration for Different domains.