We provide IT Staff Augmentation Services!

Sql Server Dba Resume

VirginiA

SUMMARY

  • Over eight years of IT experience in database Administration, Design Development and Support of MS SQL Server 2014/2012/2008 R2/2005 in Production, Test, Development and Cluster Server Environments.
  • Extensive experiences in MSSQL Server Database administration including monitoring and troubleshooting, database migrating, job automation, backup/recovery, maintenance, and alert managing.
  • Hands on Experience on installation and configuration of MSSQL Server 2008/2008R2/2012/2014,
  • Experience in database administration activities for DB Security,
  • Experience in performing administrative tasks: Database files management, Backup/restore, Database Mirroring,
  • Experience in RDBMS design, performance tuning, optimization in SQL server 2008R2/2012
  • Performed database migrations on the different environments,
  • Knowledge and experience with Security and Audit Management,
  • Expertise in AlwaysOn Availability Group(AAG) and HA/DR Troubleshooting.
  • Implemented the new SQL Server 2012 mechanisms like data compression, online indexing, contained database, security principals.
  • Experience in Replication - Snapshot and Transactional and extensive knowledge in Merge replication.
  • Handled multiple SQL Instances on Cluster environment for Server Consolidation,
  • Experience in implementing high availability using Log shipping, and knowledge of DB mirroring in SQL server 2005/2008R 2/2012/2014.
  • Experience in supporting Very Large OLTP Database and troubleshooting the performance bottlenecks.
  • Experience in writing T-SQL (DDL, DML, and DCL) .
  • Expert in implementing business logic by using T-SQL, Stored procedures, triggers (DDL, DML) and functions (inline & Multivalued Table functions.)
  • Experience in Batch processes, import, Export, Database Monitoring tools and Application support.
  • Proficient in physical, logical database design by using Erwin tools.
  • Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks.
  • Rebuilding the indexes at regular intervals for better performance.
  • Experience in using Dynamic Management views (DMV) to trouble shoot and improve server performance.
  • Experience in Disaster Recovery Planning, Execution and Security Management Operations.
  • Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS packages to SSIS, Package Migration,
  • Migration experience from MS SQL Server 2005 to MS SQL Server 2008/2008R2, MS SQL Server 2008R2 to MS SQL Server 2012/2014.
  • Extensively worked on 32 bit, 64 bit clustered and standalone server en vironments.
  • Experience in using Data Partitioning for large tables of data to increase performance.
  • Experience in using SQL server tools like SQL Server Enterprise Manager, SQL profiler, and SQL query Analyzer.
  • Experience in using SSIS (SQL Server Integration Services) for data extraction, transformation and loading across different database like Oracle, MS Access, and flat files,
  • Worked extensively in Query analyzer and profiler for tuning queries using a variable for characteristics and query costs.
  • Knowledge of Relational Database Management System(RDBMS)
  • Flexible and versatile to adapt to any new environment and work on any project.
  • Experience in Visual Studio 2005 Business Intelligence Reports, SQL Server 2005 Reporting Services (SSRS), Crystal reports.

TECHNICAL SKILLS

Operating Systems: Windows NT/2008/2003/XP/Vista, Server 2008, Linux, Unix.

Database: MS SQL server 2014/2012/2008 /2005/2000, Oracle

Database Tools: Profiler, DTS, Management Studio/Enterprise Manager, Query analyzer

ETL Tools: SQL Server Integration Services(SSIS), SQL Server Reporting Services

SQL Server: Analysis Services(SSAS),Data Transformer services(DTS)

Languages: T-SQL, Visual Basic, C#, Fortran, C++, MATLAB, XML

Data Modeling Tool: Erwin, Regate, Lit Speed

Application: Microsoft office Suite

PROFESSIONAL EXPERIENCE

SQL Server DBA

Confidential, Virginia

Responsibilities:

  • Installed and configured MS SQL Server 2012/2014 on Windows 2008/2012 Server .
  • Modeling and architecture of the SQL Server 2012/2014 databases .
  • Administrator tasks like managing users, roles and permissions.
  • Configuring, tuning and optimizing SQL Server 2008R2/2012/2014
  • Maintained the security, integrity and availability of SQL Server.
  • Implementing and Managing AlwaysOn Availability group.
  • Configuring and implementing contained Databases.
  • Managed devices and databases, scheduled tasks, monitored server and database performance, Monitored allocation of memory and procedure cache.
  • Migrating SQL Server 2005/2008R2 to SQL server 2014 d atabases on a clustered environment.
  • Created Maintenance Plans that help for the performance of SQL Server, which covers database Integrity check, update database Statistics, effective disk utilization and index maintenance.
  • Data migration using bulk copy program and DTS from Oracle Databases and Flat files.
  • Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer.
  • Planned database security measures and created and updated database document.
  • Creating SQL Server Logins and assigning Roles and Authentication Modes as a part of Security Policies for various categories of User Support .
  • Created Alerts for successful or unsuccessful completion of scheduled Jobs.
  • Diagnosing and tuning the server optimal performance using SQL Server 2012 SQL Profiler and Database Engine Tuning Wizards.
  • Performance tuning on stored procedures, indexes, and triggers.
  • Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.
  • Maintained high availability of databases using Database Mirroring and Log Shipping.
  • Transferring the data(ETL) to Data warehouse by SQL Server 20012 Integration Services.
  • Responsible for creating, deploying and scheduling new SSIS packages.
  • Migration of the data from DTS to SSIS packages.
  • Created reports using SQL Server Reporting Services.
  • Designing and testing various disaster recovery mechanisms to ensure 100% data recovery in the event of failures

Environment: SQL Server 2008R2/2012/2014 Enterprise Edition, T-SQL, Visual Studio 2010, Windows 2008 platform, SQL Profiler, DTS, SSIS, SSRS.

SQL Server DBA

Confidential, Maryland

Responsibilities:

  • Worked on SQL Server 2008R2/2012 failover clustering which is built on top of a Window server 2008 cluster.
  • Completed administration of MS SQL Server version 2008R2/2012.
  • Designed, added, eliminated, and maintained indexes, organized tables, recommended changes to application development team.
  • Appropriately tuned database applications and monitored their performance for achievement of efficient database access for applications.
  • Implementing and managing different type of replication models like Snapshot, Transactional, and Merge.
  • Involved in complete database design including conceptual, logical and physical models.
  • Performed data extraction and migration activities for populating test (or non-production) and customer databases.
  • Analyzed business recovery requirements and maintenance strategies and plans for critical databases.
  • Performed data backup, recovery, and transfer operations.
  • Effectively managed disk space using LITE SPEED for Database Backups
  • Provided maximum protection using AlwaysOn availability group.
  • Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages.
  • Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
  • Used functions to create predefined conditions and prompts to filter the data and dynamic user selection
  • Used Dynamic Management Views (DMV) for monitoring the performance of the server
  • Migrated and tested DTS packages to SQL Server 2008R2/2012 Integration Services.
  • Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.

Environment:: Windows 2005/2008, MS SQL Server 2005/2008R2/2012/2014, T-SQL, Visual Studio 2008, Crystal Reports 8.5, Lite Speed, MS Access, DTS, BCP, SSIS, SSRS

SQL Server DBA/Developer

Confidential, Addis Ababa, Ethiopia

Responsibilities:

  • Performed installation, configuration and maintenance of MS SQL Server 2005/2008R2 in development, test, and production environment,
  • Managed security on the production and development environments.
  • Monitoring server activities and resolving various performance issues by running DBCC commands, trace SQL Server Profiler, DMV, Windows performance monitor, Database engine tuning advisor, using activity monitor and execution plan,
  • Analyzed the complete environment for resource utilizations and suggested upgrades to increase I/O and avoid bottlenecks.
  • Applied service packs and hotfixes,
  • Day-to-day administration of live SQL servers,
  • Maintaining and verifying backup to check its validity and recoverability, scheduled automate jobs to take backup as per company policy, and applied different recovery model for each environment,
  • Automated consistency checks of the database (DBCC) for SQL Server.
  • Administered the space usage of the various databases for various applications.
  • Proposed and implemented various high availability options to maintain the high availability of SQL server in various environments.
  • Suggested and implemented various SQL Server services environments.
  • Upgraded SQL server 2005 boxes to SQL server 2008R2 and acted as the point of contact for all developers.
  • Tested point in time recovery of the production 2008R2 databases using the traditional backup/restore technique,
  • Configured and implemented replication and Log shipping,
  • Created and managed stored procedures, indexed view, user-defined function and trigger and database constraint to meet businesses requirements.
  • Extensively developed SQL scripts for maintaining administrative task.
  • Worked on monitoring and tuning of SQL script. Created upgraded script for production database
  • Converted many DTS packages to SSIS packages during the up gradation of the servers.
  • Involved in performance tuning and query optimization,
  • Creating SSIS packages to import and export data from various data source and destinations like Oracle, My-SQL, and Access to/from SQL Server,
  • Fixed and rebuilt many SSIS packages during the migration,
  • Analyzed many databases in MS SQL Server environment for performance issues,
  • Involved in tuning various reports generated using SSRS,
  • Documented the various observations made and suggestions on various environments,

Environment: Windows 2005/2008, MS SQL Server 2005/2008R2, SSRS, DTS, SSIS, Erwin, SQL Server Profiler, T-SQL, SQL Loader, Database engine tuning Advisor, Upgrade Advisor.

SQL Developer/DBA

Confidential, Addis Ababa, Ethiopia

Responsibilities:

  • Participated in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints,
  • Implemented Data partitioning, Error handling through TRY-CATCH-THROW statements, common Table Expression(CTE)
  • Backing up master & system databases when necessary.
  • Worked on client/server tools like SQL server Enterprise Manager and Query Analyzer to Administer SQL server.
  • Created and integrated user defined functions and stored procedures for reporting purposes.
  • Designed and developed various reports
  • Analyzed expensive queries and tune the same to optimize application and system performance,
  • Created Database Maintenance Plan for the performance of SQL server, and Re-indexing
  • Planned the complete backing up of database and restore the database.
  • Created stored Procedures, Triggers, Cursors, Tables, Views and other statements for various applications, maintained referential integrity and implemented business logic.
  • Involved in performance tuning of the database and T-SQL queries using execution plan.
  • Automated and Monitoring jobs and making sure all jobs ran successfully every night.
  • Used SQL Server profiler to monitor the performance of an instance, debug T-SQL statements and stored procedures and functions.

Environment: : Windows 2003, MS SQL Server 2005/2008R2, SQL, T-SQL, SQL Query Analyzer, Profiler

Hire Now