SUMMARY

• I am a SQL Server DBA, who has been supporting enterprise database applications for 5 plus years.
• I am a team player who is attentive to detail and able to work in a fast - paced enterprise environment.
• I have excellent oral and written communication and problem solving skills.
• I am able to make decisions independently and quickly with little or no supervision.
• Experience debugging and tuning Transactional SQL and SSIS stored procedures.
• Ability to ensure of corporate databases by protecting against the loss or misuse of information and designing backup/recovery strategies.
• Responsible for troubleshooting and problem solving of SQL Server with RCA.
• Responsible for improvement and maintenance of the databases to include release rollout and upgrades.
• Experience managing multiple MS SQL RDBMS on web-based transactions.
• Database administration including installation, configuration, upgrades, capacity planning, performance tuning, backup and recovery and managing clusters of SQL servers
• Maintenance and tuning of database and replication.
• Experience with setup and administration of SQL Server Database Security environments using database Privileges and Roles.
• Provide SQL Server database physical model creation and implementation (data type, indexing, table design).
• Third party tools worked with includes but not limited to: Redgate, Quest Litespeed, Idera, SQL Toad, MOM, BMC Remedy.
• Good leadership and interpersonal skills, coupled with a proven ability to manage a team in providing excellent customer relation and achieving growth.
• Capable of communicating effectively in spoken and written English.
• I am a motivated, energetic and goal focused professional with a consistent desire to succeed.
• Self-starter with a drive to see task through to completion and to meet deadlines.

TECHNICAL SKILLS

RDBMS: SQL 2005, SQL 2008/2008r2, SQL 2012, SQL Server 2014. Database Administration, Enterprise Environments, Tuning with SQL Profiler, Clustering, SQL Server Integration Services.

Operating Systems: Windows NT/ 2000/2003/2008/2008 R2/2012R2

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2000 and 2005 to SQL server 2008 R2 on Various Production Servers.
• Migrated Databases from SQL Server 2005 and SQL Server 2008 legacy application to SQL Server 2012 with deprecation of clustering and mirroring HA solutions and replace with Always On solution.
• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Used Policy Based Administration feature (SQL Server 2008 R2 and 2012).
• Worked With 'insert' commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005 and 2008 R2 and 2012.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Worked in Active-Active Cluster environment as a High availability solution.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Extensively used TSM litespeed backups.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS.
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan.
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Test servers.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Performed the migration of SQL Server 2000 to SQL Server 2005.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting Log Shipping.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014 with Always-On configuration

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Installing SQL Server with standard access privileges service account to improve security and to attain high ratings in Sox and PI audits.
• Installed, configured SQL Server 2008R2 Clustering on Microsoft Clustering services (MSCS) for Active-Passive and Active-Active cluster Nodes.
• Involved in Analyzing and Upgrading SQL Server 2000 servers to SQL Server 2008R2.
• Perform SQL Server service pack and Windows Service pack upgrades.
• Designed and implemented comprehensive Backup plan using Native SQL and BUR and EMC DDBoost
• Resolved and tweaked memory pressures caused during production release.
• Worked with customers on Application rollouts and server migrations.
• Migrated legacy databases with upgrade from SQL 2005 and 2008R2 to SQL 2012 and SQL 2014 with Always-On configuration.
• Supported Very Large databases (VLDB) and troubleshooting related problems.
• Strong experience in mentoring team members and writing documentation.
• Troubleshoot performance problems and fine-tuning of databases.
• Expertise in designing databases and capacity planning.
• Experience with rebuilding the indexes and statistics update at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Worked extensively with Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Monitored and modified Performance using execution plans and Index tuning.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Implemented and Scheduled Replication process for updating our parallel servers in autonomous sites.
• Designed and created databases, tables, views, store procedures and triggers.
• Handling Memory configurations for SQL Server 2012 and SQL Server 2008R2 on Windows 2008R2.
• Experience in Batch processes, Import, Export, Backup, Database Monitoring tools and Application support.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.

Confidential, Sacramento, CA

Customer Service Rep.

Responsibilities:

• Managed all retail and online related customer contacts.
• Provided quality responses to customer contacts in person, telephone & email. Dealing with enquiries & answering calls from new and existing customers.
• Suggested solutions to customers in a positive manner.
• Dealt with all escalated complaints and enquiries efficiently and effectively.
• Communicated promptly any information to customers about their orders.
• Helped customers to register online and/or to process their orders.
• Gave customer’s information about company services and products.
• Built relationships with customers.
• Recorded all queries and made notes on logging software.
• Resolved assigned incidents within pre-agreed timescales.
• Familiar with all with Microsoft packages
• Handled difficult and aggressive customers in a professional manner.
• Assisted the finance Department with customers on security checks

Confidential

Solicitor Legal Assistant

Responsibilities:

• Assisted solicitors in various matters concerning real estate, social services, criminal justice, family matters and common law cases.
• Gained practical experience and knowledge in legal issues and terminology.
• Prepared and interpreted legal documents.
• Prepared pleadings, subpoenas, and other legal documents.
• Scheduled appointments, court appearances, and depositions.
• Advised clients on legal issues relating to their cases.
• Under took legal research.
• Acted for an international company, involving the drafting of confidentiality agreements, employment contracts and license agreements.
• Attended at tribunal - DLA and ESA appeals.
• Negotiated settlements and outcome for clients.
• Involved in setting up a limited liability company and drafting partnership agreement.
• Drafted Board Minutes, Resolutions and Companies House forms and updating statutory books.
• Proof read and amended in house articles, updates, loan agreements and commercial contracts.
• Provided on-going lease management advice to corporate landlord, dealing with tenants’ applications for Licenses to assign, alter, sublet and drafted Deeds of covenant and rectification.
• Drafted and negotiated Authorized Guarantee Agreements.
• Produced Lease Management Schedule and advised the clients on key terms.

Confidential

Operations Manager (Domiciliary Care) Assistant

Responsibilities:

• Provided operational and commercial leadership by managing office and care staff.
• Ensured services met the governing body and other regulatory requirements.
• Managed the delivery of domiciliary care.
• Provided personalized, focused services for service users.
• Liaised with, and maintaining excellent relationships with care managers, doctors, nurses, local authorities, families, service users and staff.
• Developed the organization by identifying new business opportunities, networking and maintaining business relationships.
• Conducted interviews with service users and their families.
• Maintained accurate records and prepared reports for legal purposes.
• Visited Services users at their home to work out appropriated care plan and support.
• Provided information and counselling support to service users and their families.
• Participated in training, supervision and team meetings.
• Updated policies and procedures.