Associate SQL DBA Resume

SUMMARY

Seeking assignments as a SQL server Production Database Administrator with a technology driven organization.
Having 3+years of work experience in managing databases in production support environment on windows platform.
Presently working with Andromeda Mkt. Pvt. Limited as Software Engineer role as Production Database Administrator.
Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.
Hands on experience in configuring, installing, managing, monitoring and troubleshooting SQL Server 2005/2008/2008R2.
Experience in performing regular Backups (Full/Differential/Transaction Log Backups into Disk) and scheduling tasks.
Experience in monitoring and optimizing the performance of the database.
Experience in monitoring data activities (i.e. database status, logs, space utilization, locks and long transactions).
Experience in high availability services like Mirroring, Replication and Log shipping.
Checking Fragmentation and Resolving Fragmentation issues.
Maintenance of database with the activities of shrink database, Indexing and Re - indexing of database.
Ensuring Data consistency in the database, Daily Log checking for errors on Production Server and Monitoring.
Managing Security (Creating users, logins and roles, granting permissions).
Performance tuning. DBCC, DMV commands, Data compression.

TECHNICAL SKILLS

RDBMS: SQL SERVER 2005/2008/2008R2/2012,SSIS

Operating System: Windows Server 2008

PROFESSIONAL EXPERIENCE

Confidential

Associate SQL DBA

Environment: Microsoft SQL Server 2008R2 on Win Server 2008

Responsibilities:

Installation, Maintenance and Monitoring the Database software products and provided technical advice to the Application Team.
Implemented and Recommended High availability configurations.
Performed Database Backup strategy and overall other strategies as per Client requirements.
Managing the users including creation/alteration, granting DB roles and permissions on various Database objects.
Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
Monitoring of database size and disk space in Production environments.
Configured Transactional Replication, Log Shipping with SQL Server Management Studio as well as basic account management, troubleshooting with connectivity, security and firewall issues.
Customized support for Client’s Applications (e.g. Third party supported/In-House Applications etc.) provided client will won the responsibility of creating and maintaining database objects and structures (e.g. tables, indexes, views, triggers, Functions, Procedures etc.).
Used SQL Server Profiler to monitor the server performance, debug T-SQL and slow running queries.
Worked on DMVs, DBCC, Mirroring, and Replication, Maintenance of existing project by fixing bugs and implementing Change Requests.
Checking the error logs and sql server error logs.
Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
Making data available to all the resources using the Transactional Replication.
Resolves if any backup or other job failures.
Used BCP utility to publish table output to text files.

Confidential

Software Developer

Environment: Microsoft SQL Server 2005 on Win Server 2003

Responsibilities:

Administering SQL Server Production Database.
Proficient in creating function, store procedure, trigger, view, Indexes and user define function in sql server.
Performed all aspect of database administration including backup recovery, Replication.
Backup client databases and perform database restore and run consistency checks from SQL Server and application.
Tuning slow running queries and procedures.
Monitor the status of Maintenance jobs schedule to run daily and on weekends (tasks like rebuilding indexes).
Checking the error logs and sql server error logs.
Maintenance of Log shipping and replication.
Rebuilding the indexes at regular intervals for better performance.
Creation of database users and assigning permissions.
Capacity planning and monitoring database growth.
Find out long running query, procedure and views using SQL Server profiler and tune the query for better performance.
Minimize log file size using log backup and after that shrinking the database.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship