We provide IT Staff Augmentation Services!

Sr. Sql Server Dba Resume

0/5 (Submit Your Rating)

Seattle, WA

SUMMARY

  • Having 8+ years of experience in Microsoft SQL Server 2000/2005/2008 - Database Administrator (DBA) in Development, Production, Test and cluster Server Environments.
  • Experience in Server Installation, Configuration, Upgrade, Maintenance and Patch management.
  • Expert in administrative tasks scheduling Backup and Recovery Strategies and Disaster Recovery Procedures.
  • Expert in using different Recovery Models simple, full and bulk-logged depending on availability of databases.
  • Design, Installation, configuration, implementation, user administration (security), monitoring and troubleshooting of MS SQL Server 2008/2005/2000.
  • Experience with various RDBMS Systems like Oracle, SQL Server, Sybase, MS-Access and other data sources.
  • Highly experienced with SQL Server up gradation & Upgrade Advisor (In place & Side-by-Side) for large and mission critical applications from 2000/2005/2008
  • Extensive experience in Administering data bases across different environments like Design,Development,UserTest,Production and Disaster Recovery
  • Experience of Database Development and data modeling with Visio and Erwin data modeling tools.
  • Hands on experience with SQL Server development and Confidential -SQL in writing stored procedures, creating user defined functions, constructing triggers, tables, views, indexes and user profiles.
  • Involved in Security Administration, Managing schemas (2008/2005), creating Credentials, creation of users, configuring permissions (Role-based and explicit), and Linked Servers and assigning roles to users.
  • Scheduling & Monitoring Daily Jobs, DB-Maintenance Plans, Run DBCC jobs for Re-indexing, Check-DB, Fragmentation across all SDLC environments.
  • Comprehensive knowledge of high availability Technologies, including SQL Server Clustering (A/A, A/P), Log shipping, DB-Mirroring and Replication.
  • Strong knowledge in disaster recovery, backup/restore and 3rd party tool integration (SQL Lite-speed, BMC tools).
  • Experience in analyzing database performance using Performance Monitor, SQL profiler, Database Tuning Advisor (DTA)), Trace Flags and allocate server resources to achieve optimum database performance.
  • Involved in using SQL2008 features like creating DB partitioning, file groups and Database Snapshots.
  • Manage database application deployments across all SDLC environments like Dev, build, test, production environments.
  • Assess and develop long-term strategic goals for Application databases in conjunction with data owners and department managers.
  • Involved in development and Support of ETL activities using DTS/SSIS/Bulk Insert/BCP Utilities for data transfers involving multimillion records.
  • Thorough understating on RAID Levels, Server Configurations, DB Striping (Data Files, Index files, temp-db), Object Normalization and De-Normalization techniques.
  • Handled extensive 24\7 production issues (Space, Tran log Issues, Process Deadlocks, Batch Process performance and nightly on-call rotation.
  • Working Experience in designing, implementing, maintaining, and documenting complex database applications.
  • Involved in Query Tuning by looking Confidential Indexes, joins, coding standards with the help of Execution Plans, query plans SQL Profiler, DTA Performance tools etc...
  • Solid background with data integrity methodologies enforcing referential integrity, constraints, indexes and Confidential -SQL Structures.
  • Documentation of procedure and policies for migrations and Change Control Management
  • Strong interpersonal skills, analytical ability, communication skills, writing skills, highly organized to meet the deadlines and ability to grasp and adapt to the rising technologies.

TECHNICAL SKILLS

RAD Tools: Visual Studio.Net 1.1/2.0/3.5 (VB.Net, C#.Net, ADO.Net), Windows Services, VBA, VB 6.0, ADO 2.6, Delphi 5.0 / 7.0

Tools: MS Office 97/2000, SCOM 2007, MS Outlook 97/2000, BizTalk server, TOAD, Lite Speed, Red Gate, SCOM, HTML, MS Office, Avamar, and Idera.

Web Technologies: ASP, IIS 6.0, ASP.Net 1.1/2.0/3.5, Web Services, Flash 5/MX

Database: Database Design using SQL Server 2000/2005 & Oracle 8i/9i/10g Database scripts using TSQL and PL/SQL (Stored Procedures, Triggers, Functions, etc) Database Maintenance using MS Access 97/2K. MS access, Oracle 9i/10g.Microsoft SQL Server7.0/ 2000/2005/2008 /R2, 97/2000/2003 , MySql, DB2, Teradata

SQL Server: MS SQL Server Enterprise manager, Profiler, DTS, Query Analyzer, Management Studio, SQL 2005 Integration Services (SSIS), Reporting Service (SSRS), and Analysis services (SSAS) (BIDS), SQL Profiler, SQL CMD, Database Tuning Advisor, Performance Monitor.

Programming Languages: C, C++, Confidential -SQL,PL SQL, Java, VB.Net, C#.Net

Scripting & Markup Language: HTML, XML, VB Script, Java Script

Operating Systems: Windows 95 / 98 / NT / 2K / XP / /2008, Linux, UNIX

Version Control: CVS 1.3, Visual Source Safe

PROFESSIONAL EXPERIENCE

Confidential, Seattle, WA

Sr. SQL Server DBA

Environment: Windows 2008/2003/2000 , MS SQL Server 2000/2005/2008 /R2, Integration services (SSIS), Reporting Services (SSRS), Confidential -SQL, SCOM 2007, .Net, DTS, SQL Agent, BizTalk Server and Idera.

Responsibilities:

  • Installation and configuration for Setup of SQL Server 2005/2008R2 server on Production, Development and Testing Environments.
  • Upgrading SQL Servers from 2000/ R2 (Dev/Test/Production environments) with side-by-side, In-Place upgrades and usage of Database Upgrade Advisor
  • Rollout Service packs, Hot-fixes, Patches across environments on a needy basis.
  • Involved in Designing Database objects like tables, Indexes, Views, Create stored procedures, Triggers, UDF’s.
  • Involved in Day today administration activities like creating Logins, Users, Schemas, Windows logins, Creating Roles, Granting permissions & Troubleshooting user permission issues.
  • Monitoring backup & Restore Jobs using SQL Lite-speed and device methodologies for disaster recovery for both production and test SQL Server databases.
  • Configured some of the critical production databases for Log-shipping to make them high available.
  • Designed and implemented complicated replication (Transactional, snapshot) within SQL Server using customized stored procedures to maintain data integrity.
  • Created linked Servers and enable distributed queries OLEDB data sources.
  • Troubleshooting performance issues, fine-tuning queries and stored procedures using SQL Profiler Trace files and Query Plans, Trace-flags.
  • Provided Ad hoc queries and Reports for Companywide users pulling data from Multi-terabyte data warehousing systems using SSRS 2005.
  • Created SSIS packages to load customer information from various sources (ETL).
  • Involved in package migration from DTS to SSIS, running upgrade advisor against DTS Packages before migration, troubleshooting issues and conversion into SSIS through wizard or manually.
  • Implemented SSIS data transformation scripts, created maintenance procedures and provided data integrity strategies.
  • Involved in Installation, Configuration and support of SSRS 2008/2005 Server and Reports across all environments.
  • Involved in Supporting Mission critical databases 24/7 on rotation call basis.
  • Participated in application development process and code reviews of database objects.

Confidential, Atlanta, GA

Sr. SQL Server DBA

Environment: Windows 2003 Advanced Server, MS SQL Server 2005,Integration services, Analysis services, Reporting Services, Confidential -SQL, SCOM 2007, .Net, DTS, SQL Agent, BizTalk Server and Idera.

Responsibilities:

  • Providing dedicated support to all Production, QA & Development MS SQL Server Environments.
  • Responsible for the Tickets assigned to SQL database Queue related to application Databases
  • Involved in the Change Requests as per Change Management Schedules.
  • Worked on CDC to integrate the data by capturing the changes made to enterprise data
  • Coordinating with the Offshore DBA Support Team on production support issues.
  • Job Scheduling & Re-Scheduling on Production Databases.
  • Scheduling and executing DTS Packages and SSIS Packages based on user requests.
  • Involved in archiving and pulling the old data in datawarehouse of the company.
  • Created reports using SSRS.
  • Created MS Excel Pivot tables to produce meaningful data from SQL entities.
  • Retrieved data from SSAS cubes using MDX queries.
  • Wrote optimized Confidential -SQL stored procedure to improve performance, preserve referential integrity and provide application functionality.
  • Extensive use of Stored Procedures. Writing and fine tuning stored procedures using MS SQL 2005 and modifying existing ones and tune them such they perform well.
  • Proper use of Indexes to enhance the performance of individual queries and enhance the Stored Procedures.
  • Worked on DBCC utilities.
  • Involved in different DR strategies with Log shipping, Replication and Clustering.
  • Checking the Status of Servers, Drive Sizes, Backup Schedules, Data Base Maintenance Plans and Job Schedules on Application Databases.
  • Involved in database backups & restoration, backup strategies, scheduling.
  • Supporting Users for their Business needs and working on the user requests from time to time.
  • Performance Monitoring on Production Databases as and when required.
  • Implementing the Data Changes, Scripts and new Releases onto the Production Servers.
  • Managing Security issues in Production environments.

Confidential, Chicago, IL

SQL Server DBA/ Developer

Environment: SQL Server 2005, Confidential -SQL, Windows 2003 Server, DTS packages, Db Artisan, MS Access 2003

Responsibilities:

  • Installation and configuration of MS SQL Server 2005 on Windows 2003 Servers and then migration of SQL 2000 Databases to SQL 2005.
  • Involved in making ERD’s and Logical Data Modeling using ERWIN.
  • Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques.
  • Creating and managing schema objects such as tables, views, indexes, procedures, triggers and maintaining Referential Integrity.
  • Implemented server security as SQL server standard security functions integrated with windows account security measures.
  • Worked on DBCC utilities.
  • Managing of SQL server user logins by using various stored procedures such as sp addlogin, sp grantlogin, sp denylogin, sp revokelogin, sp grantdbaccess etc.
  • Frequently monitoring the role membership to make sure that no one has given the extra access than assigned.
  • Facilitate and manage efficiently the transactions by OLTP.
  • Provide support for the application migration, testing, and database tuning, including interacting with the application team for problem diagnosis and resolution.
  • Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Performed log shipping. Performed snapshot replication.
  • Administrator tasks like managing users, roles, and profiles.
  • Worked on Active/Active Clustering.
  • Migrated DTS packages using SSIS.
  • Performance tuning by using SQL profiler, and Monitoring of SQL server.
  • Monitor the size of the transaction log. Managed databases on multiple disks using Disk Mirroring and RAID technology.
  • Involved in creating and optimizing the stored procedures and database triggers.
  • Developed standards and guidelines to maintain and develop and administer the SQL Server database.

Confidential, Denver, CO

SQL Server DBA/ Developer

Environment: MS SQL Server 2005,2000, DTS, Flat files, SQL Server 2005 Management, Confidential -SQL, Windows 2003 Server, ERwin, Business Intelligence - SSIS, SSAS, SSRS, SQL Agent, SQL Profiler, RAID, Database Tuning Advisor, Database Mail, Litespeed, IIS, Oracle.

Responsibilities:

  • Involved in gathering user Requirements, application design, and analysis of hardware requirements to meet business needs.
  • Responsible for configuration of Microsoft Server/Client Products and implementation.
  • Developed various Confidential -SQL stored procedures triggers, views, and adding/changing tables for data load and transformation, and data extraction.
  • Responsible for database tuning using normalization, de-normalization and application tuning.
  • Involved in optimizing code and improving efficiency in databases including re-indexing. Updating statistics, recompiling stored procedures and performing other maintenance tasks.
  • Handled up to 2 TB Size databases with clustered and replication environment.
  • Regular Database backing up and implementing tests on that backup and generating reports.
  • Extensively worked on Dynamic Management Views (DMV’s) to get the information about executed Confidential - SQL statements.
  • Used Idera SQL safe backup which provides a high-performance backup and recovery solution.
  • Worked on Data Partitioning, Database Mirroring and Snapshot Isolation in SQL Server 2005.
  • Incorporated business logic in SSIS while converting from Oracle, MS Access and Text to SQL Server.
  • Creating new database/tables to put in the extracted data and rebuilding the relationship.
  • Maintained the consistency of the client’s Database using DBCC.
  • Configured and maintained transactional and merge replication for 2 environments.
  • Backing up, restore system and other databases as per requirements, and also scheduled those backups.
  • Involved in SQL Server disaster recovery procedures. Responsible for Stored Procedures optimization, Performance tuning & index tuning.
  • Monitoring the server usingSQL LiteSpeed Backup tools.
  • Experience in migrating SQL 2000 to SQL 2005, and various transformations in SSIS Package.
  • Good hands on experience in SQL Server Manager’s SQL Server Agent jobs.

Confidential, CA

SQL Server DBA/ Developer

Environment: Windows 2000 Advanced Server/Server 2003, MS SQL Server 2000, TSQL, XML.

Responsibilities:

  • Performing Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments.
  • Participating in weekly Systems and DB Meetings and updating the Project status to the Project Manager.
  • Handling database objects with Enterprise Manager and Query Analyzer.
  • Administering 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.
  • Plan and Schedule the Online/Offline Backups.
  • Database and Log Backup, Restoration, Backup Strategies, Scheduling Backups. Backing up master & system databases and restoring them when necessary.
  • Perform Capacity Monitoring and short and long-term capacity planning in collaboration with development resources, System Administrators and System Architects.
  • Maintaining server for database, SQL jobs. Performance tuning of SQL server. Using the Database Maintenance Wizard to make some necessary changes and keeping the performance of the server Confidential acceptable levels.
  • Automated processes using SQL Server jobs.

Confidential

SQL Server DBA/ Developer

Environment: MS SQL Server 7.0/2000, Confidential -SQL, Excel, Confidential -SQL, DTS, Windows2000. SQL Server Query Analyzer, SQL Profiler, Database Tuning Advisor, Database Mail SQL.

Responsibilities:

  • Involved in data modeling and design of databases, tables and all objects.
  • Designed, coded and tested several Confidential -SQL programs.
  • Created DTS packages for uploading various formats of files and databases to MS SQL.
  • Created tables, views, indexes, stored procedures, triggers and constraints.
  • Suggested different plans for Replication.
  • Troubleshoot different conflicts between two servers in Replication.
  • Managing the use of disk space, memory and connections.
  • Used DBCC commands for database consistency.
  • Running production scripts on test environment.
  • Monitor SQL Error Logs, Schedule tasks, database activity.
  • Involved in Configuring the Log shipping to create the Standby server.
  • Modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.

We'd love your feedback!