SUMMARY:

A self - motivated and results-oriented MSSQL Server Database Administrator with over 7 years of professional experience implementing and maintaining SQL Server solutions in a high - technology Enterprise environment. A quick learner who can absorb new ideas and can communicate clearly and effectively.

EXPERIENCE:

MSSQL SERVER DBA

Confidential, Snellville, GA

Responsibilities:

• Experience in building and configuring SQL Servers as well as providing security, creating logins, users, roles and assigning permission to them.
• Responsible for the integrity of our SQL server systems including maintenance routines, automated monitoring solutions, backup and disaster recovery strategy
• Responsible for developing and maintaining, conceptual and physical models, Data access strategy for applications and internal teams, Data integration strategy, Data quality checks
• Database deployments and configuration management
• Diagnose and resolve database performance issues
• Document the company’s database environment
• Work as part of a team and provide 7×24 supports when required.
• Interface with MSSQL/MySQL/Oracle for technical support
• Design indexes for existing applications, choosing when to add or remove indexes
• Work across departments to ensure the database design is meeting the needs of both internal and external clients
• Responsible for adherence to corporate standards, build process guidelines, maintainability, unit tests of SQL Server projects
• Establish and maintain sound backup and recovery policies and procedures.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Database tuning and performance monitoring.
• Finding DMV queries to answer questions about server-level performance
• Setup and maintain documentation and standards and plan growth and changes (capacity planning). .
• Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
• Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
• As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring or Always ON
• Perform routing database migrations to support database refreshes from production to test and database consolidation efforts.
• Setup automation with SQL Agent and Database Mail for Maintenance, error alerting and job failures

MSSQL SERVER DBA

Confidential, AUSTIN, TEXAS

Responsibilities:

• Managed and worked with third party tools like SQL Sentry, GoldenGate, Attunity in providing support to the environment.
• Installed Service Pack and Hot fix and security patches on network computers and performed full backup, Trans log backup, Differential backup, and restore them if needed
• Rebuild index, update statistics, shrink log files, clean up maintenance tasks
• T-SQL code reviews before deployment and recommend when needed adjustments that could enhance the codes performance.
• Plan, create, implement, and maintain database maintenance plans including DBCC and all supporting documentation.
• Setting up and administering SQL Server Database Security environments using Profiles, database Privileges and Roles to prevent data theft and increasing data integrity
• Writing, debugging, and tuning T-SQL, ETL and Stored Procedures for system performance
• Review logs, Updates database statistics and index management
• Using SQL loader in loading data into oracle and SQL database from DB2 extracts
• Responsible for Maintenance, Backup & Recovery, Testing, Alerts and Database integrity checks
• Trouble shoot and tune the queries, indexes, and stored procedures due to performance issues with SQL Server Activity Monitor, T-SQL, SQL Server Profiler, and Execution Plan
• Set up SQL cluster, mirror, replication, and log shipping
• Migrated MS SQL Servers legacy systems to new systems like 2000, 2005 and 2008r2 to 2014
• Recommend, develop and implemented Sequences as against Identity Columns, Migrated identity columns to Bigint.
• SQL Server upgrades, database unification and application enhancement
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc.
• Handling Logical Data and Index partitioning for large tables in SQL Server 2005 and 2008
• Monitored application availability, databases, troubleshooting application and customer issues related.
• Continuous evaluation of database performance and the identification of problem areas

DATABASE ADMINISTRATOR

Confidential

Responsibilities:

• Modified stored procedures to meet current design and used them in SQL Server.
• Write, debugged, and tuned Transactional SQL, ETL and stored procedures
• Review logs, Updates database statistics and index management
• Ensured definition and development of database documentation and standards and applied problem
• Solving skills and root cause analysis to resolve and/or mitigate IT operational issues.
• Designing, Implementing and maintaining Database Schema, Entity relationship diagrams, Data modeling,
• Tables, Stored procedures, Functions and Triggers, Constraints, Indexes, Schemas, Functions, Views,
• Rules,Defaults and complex SQL statements.
• Interpreted data from primary and secondary sources using statistical techniques and provide ongoing reports.
• Performed T-SQL code reviews before deployment and recommend when needed adjustments that could enhance the codes performance.
• Created user account according to audit standards and trouble shoot for orphan user issues.
• Assisted in establishing standards and schedules for database backups by making sure that the backup schedules meet the recovery requirements on a daily, weekly, and monthly basis
• Performed full backup, Trans log backup, Differential backup, and restore them if needed
• Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Set up and administered SQL Server Database Security environments using Profiles, database Privileges and Roles.
• Ensured Database performance monitoring and tuning is regularly accomplished to prevent downtime
• SQL Server database physical model creation and implementation (data type, indexing, table design).