SQL Server Database Administrator Resume Samples

Description :

1. GPS is a global payments hub with a sophisticated payment infrastructure that unifies the connectivity for clients around the globe.
2. GPS is responsible for creating, maintaining and approving payment transaction of the clients.
3. GPS Web services team is responsible for developing and consuming web services to enable payment processing.
4. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
5. Rebuilding the indexes at regular intervals for better performance Involved in troubleshooting and fine-tuning of databases.
6. Monitored and modified Performance using execution plans and Index tuning.
7. Rebuilding the indexes at regular intervals for better performance.

Experience

2-5 Years

Level

Junior

Education

Diploma

Description :

1. Installed and Configured SQL Server 2005/2008 R2/2012 Servers in Development, Staging, and Production Environments.
2. Created databases, logins, roles, and granted appropriate permissions.
3. Created schedule jobs, alerts, activity logs, error logs to capture any possible errors.
4. Evaluated database performance and performed maintenance duties such as tuning, backup, restoration, and disaster recovery.
5. Supported 247 production support and solved all kinds of critical problems. Gather client project requirements.
6. Performed requirements analysis & specification design for data conversion process, determined functional.
7. Exported reports into various formats and resolved formatting issues.

Experience

2-5 Years

Level

Junior

Education

Diploma

Description :

1. Installing, Configuring and Maintaining SQL Server 2008R2/2012/2014 on Active/Active Cluster with the latest Service Packs, Hot Fixes.
2. Created stored procedures, views, triggers, user-defined functions to apply business rules to the data.
3. Experience in SQL Server Reporting Services, Report Builder for generating reports y analyzing data.
4. Work with application development staff to abide by database architectures, coding standards, and quality assurance policies and procedures.
5. Work with Application Development Manager to create models for new database development and/or changes to existing ones.
6. Monitor Log shipping/Transactional Replication and troubleshooting of errors.
7. Participated in SDLC methodologies such as planning, analysis, design, and implementation.

Experience

7-10 Years

Level

Management

Education

Diploma

Description :

1. Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts.
2. Perform Full Backups and Transaction Log Backups. Managing database objects like Tables, views, indexes.
3. Creating back up strategies and scheduling them for execution.
4. Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
5. Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
6. Backing up the entire user's database and scheduling the backup process.
7. Performed basic and advanced database back-up and maintenance duties.

Experience

2-5 Years

Level

Junior

Education

Diploma

Description :

1. Migrated SQL Server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
2. Set up and monitor High-Availability(HA) and Disaster Recovery(DR) technologies including mirroring, log shipping, replication.
3. Optimize SQL queries for improved performance and availability.
4. Develop, test & implement a robust database backup and recovery strategy.
5. Migrated SSIS packages from SQL Server 2008 R2 to SSIS 2012.
6. Migrating Disaster recovery databases into a cloud - Microsoft AZURE.
7. Extensively worked on SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS).

Experience

5-7 Years

Level

Consultant

Education

Diploma

Description :

1. Installed SQL Server 2000 and 2005 servers, applied service packs and a security fix.
2. Experienced in upgrading from SQL Server 2000 to SQL Server 2005. Worked on a change management ticketing system.
3. Experienced in granting permission to the SQL Developers and application users.
4. Responsible for database capacity planning and advice the system engineers for future hardware requirements.
5. Experience in creating the stored procedures, triggers and views.
6. Worked with the SQL Developers to create a new database design that acquired the business information from Business analysts.
7. Experience in tuning the SQL Queries and Stored procedures.

Experience

5-7 Years

Level

Executive

Education

Technology

Description :

1. Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
2. Analyze long running slow queries and tune the same to optimize application and system performance.
3. Rebuilding the indexes at regular intervals for better performance.
4. Designing and implementing a comprehensive Backup plan and disaster recovery strategies.
5. Troubleshooting and fine-tuning of databases for its performance improvements and concurrency.
6. Monitored and modified Performance using execution plans and Index tuning.
7. Deploying a new code base release to UAT and Production Environments. Perform SQL Server service pack and Windows Service pack upgrades.

Experience

7-10 Years

Level

Management

Education

Business Administration

Description :

1. Upgraded and migrated SQL Server 2005 databases, database objects, SSIS packages, and SQL Server Agent jobs to SQL Server.
2. Performed backup and restores of databases.
3. Verified, daily, the backups that maintain and store on a Tivoli Storage Manager server.
4. Implemented HA/DR using database mirroring and participated in DR exercises.
5. Troubleshot data-driven application(s) using SQL Profiler, SQL Server Logs, Performance Monitor, SQL Server system views.
6. Created and updated SSIS packages as well as updated DTS packages.
7. Wrote Powershell scripts for RDBMS management and maintenance.

Experience

5-7 Years

Level

Executive

Education

BS

Description :

1. Design, build and maintain various components of databases for Nextel's Customer Finance Operations.
2. Build and maintain several statistical reports and projects for managers and directors. Create, track, and maintain departmental budgets.
3. Perform trending and cost-benefit analysis as well as forecasting reports up to 18 months.
4. Build rapport with other internal departments acting as a liaison with the reporting team.
5. Build and maintain several Oracle and SQL Server databases.
6. Expert with Enterprise Manager, Toad, Access, Microsoft Office Suite, Crystal Reports and Business Objects.
7. Build reports and presentations that influence mission-critical decisions.

Experience

10+ Years

Level

Senior

Education

Diploma

Description :

1. Created databases, logins, roles, and granted appropriate permissions.
2. Created schedule jobs, alerts, activity logs, error logs to capture any possible errors.
3. Evaluated database performance and performed maintenance duties such as tuning, backup, restoration, and disaster recovery.
4. Supported 247 production support and solved all kinds of critical problems.
5. Participated in SDLC methodologies such as planning, analysis, design, and implementation.
6. Setup Log Shipping and Mirroring for day one critical database as a High Availability Solution.
7. Setup Replication (both Transactional and Merge replication) for multiple points of presence for business data.

Experience

5-7 Years

Level

Executive

Education

Engineering

Description :

1. Optimization of existing databases by data reduction, applying referential integrity and normalization of data.
2. Coordinate efforts effectively across departmental groups and end-users.
3. Backup and recovery duties in an environment with databases exceeding 15 TB.
4. Monitor all database activities and resolve or report issues as they arise.
5. Serve as the Security Administrator for SQL Server as well as a Group Network Security Administrator.
6. Researched and applied all required service packs for all servers.
7. Experience with capacity planning, trouble-shooting database corruption, backup, and recovery.

Experience

2-5 Years

Level

Junior

Education

Masters

Description :

1. Applied patches and service packs to keep the database at the current patch level.
2. Created Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user-defined data types, and functions.
3. Suggested Disk Capacity, Processors and Memory based on Capacity planning.
4. Troubleshooting Problems by using the SQL Server profiler. Involved in tuning the databases for best performance.
5. Solved critical production problems and developed point in time recovery plans. Managing SQL Server logins, users, roles and permissions.
6. Creating Database Objects like Tables, Stored Procedures, Views, Triggers and functions in Production and Test environment.
7. Setting up SQL Database Mirroring in maximum Performance Mode (Asynchronous) as a Business continuity solution.

Experience

2-5 Years

Level

Junior

Education

Economics