We provide IT Staff Augmentation Services!

Sql Database Administrator Resume

Richmond, VA

SUMMARY

  • Over four(4) years of experience in installing, upgrading, patching, administrating and maintaining Microsoft SQL Server 2005/2008/2008 r2, 2012 and 2014 database servers in Production, Test and Development environments
  • Experience with recovery models and providing backup and restore functions for MS SQL Server databases
  • Experience with SQL/T - SQL for creating, altering, and maintaining databases and database objects
  • Proactively monitoring and troubleshooting database issues (e.g., Memory, CPU, I/O, disk utilization, blocking, deadlock, fragmentation, etc.) And make tuning adjustments to ensure database integrity, security and system performance (using native tools like PerfMon, Profiler, Execution Plan, Database Tuning Advisor, DMVs, DBCCs, etc.)
  • Configuring, maintaining and monitoring and troubleshooting HA/DR solutions - Log Shipping, Mirroring, Replication
  • Participated in the installation and configuration of SQL Server 2012 Failover Clustering
  • Experience with user management and security of Microsoft SQL Server
  • Experience in creating, setting up and scheduling jobs for database administration
  • Experience in setting up and configuring Database Mail, notifications and alerts
  • Experience in creating, supporting and maintaining database administration scripts
  • Install/configure/secure/deploy reports/administer SQL Server Reporting Services (SSRS)
  • Experience with Data Extraction, Transformation and Loading (ETL) using SSIS, BCP and Import/Export Wizard
  • Expertise in RDBM concepts and constructs; working with data modelers on logical and physical data modeling; working with DBAs/Developers in implementing and updating physical data models in databases
  • Performed data asset identification and ensured that activities, incidents and changes are documented in accordance with established organizational procedures
  • Working experience with developers, application owners, system administrators and users to deploy software release across Development, Testing, and promoting into Production or resolve issues
  • Working experience with Windows Server Operating Systems, Windows NT 4.0
  • Professional, Windows 2000 Professional, Windows XP Professional, MS-DOS
  • Knowledge and skills with C, C++, Java, Visual Basic, .NET Framework, VBScript, JavaScript, HTML, XML
  • Knowledge and skills from various fields - Information Science/Computer Science/Information Systems, journalism, Mathematics
WORK EXPERIENCE

SQL Database Administrator

Confidential

Responsibilities:

  • Installed, configured, and managed SQL Server 2014/2012/208 R2/2008 in development, test, and production environments
  • Applied Service Packs (SPs) on SQL Server 2008, 2008R2 and 2012.
  • Migrated/Upgraded databases/instances from SQL Server 2008/2008R2 to 2012
  • Developed, maintained and implemented database backup and recovery plans for Production, Test and Development environments including mission critical databases
  • Performed backups and restored databases from backups
  • Refreshed database in test and development environments from production servers
  • Regularly checked databases consistency
  • Installed, configured and/or maintained HA/DR solutions - Log Shipping, Mirroring and Transactional Replication
  • Involved in the installation and configuration of SQL Server 2012 Failover Clustering
  • Installed, configured, secured, and maintained SQL Server Reporting Services (SSRS) and deployed reports
  • Move data from Flat file, CSV file, Excel, Access, OLE DB data sources to/from SQL Server database using SSIS, BCP and/or Import/Export wizard
  • Setup and configured Database Mail and configured notifications and alerts
  • Created maintenance plans and scheduled jobs to automate different database administration related tasks
  • Monitored if scheduled jobs/ SQL agent jobs have run successfully on a daily basis and troubleshoot, and fix if any jobs failed
  • Monitored SQL Server activities/issues (such as CPU utilization, Memory utilization and IO utilization, disk space issues, blocking, deadlock, fragmentation, Identifying indexing issues, managing indexes, growth patterns, etc. ) and optimized performance using Execution plan, PerfMon, Profiler, Database Tuning Advisor, DMVs and DMFs, configuring multiple file structures for separation of data file, log file, TempDB, etc.
  • Regularly inspected SQL Server Logs, SQL Server Agent Error Logs, and Windows Event Viewer for Information, errors and warnings
  • Used SQL/T-SQL to create, alter, drop, delete, insert, update, etc. of databases, tables, views, clustered and non- clustered indexes, schemas, triggers, functions, stored procedures, and so on
  • Secured, managed and created logins, users, roles and granted permissions of database objects
  • Assisted SQL Server Database Developers in code review and optimizing SQL queries
  • Provide technical support to resolve problems, test solutions, and implement fixes

SQL Database Administrator

Confidential US - Richmond, VA

Responsibilities:

  • Installed, Configured and Administered database and related products - SQL Server 2012/2008R2/2008/2005- in development, test and production environments
  • Upgraded databases from SQL Server 2005 to 2008R2 and 2008R2 to 20012 in testing and production environments
  • Applied Service Pack (SP) on SQL Server 2008 and 2008R2
  • Deployed database objects/changes to different environments including production
  • Performed database refreshes in test and development environments
  • Performed database backup and Restore (including Point-in-Time Recovery)
  • Setup, configured, monitored, and troubleshoot Log Shipping and Database Mirroring
  • Installed, configured and managed SQL Server Reporting Services (SSRS), created and deployed reports
  • Move data to/from Flat file, CSV file and OLE DB data sources to/from SQL Server Database using SSIS, BCP and/or Import/Export Wizard
  • Created and modified tables, index (Cluster/Non-Cluster), constraints, views, stored procedures, triggers
  • Performed regular monitoring and performance tuning
  • Scheduled jobs and created maintenance plans to automate different database related activities including backup and database consistency check
  • Monitored growth of database objects for capacity planning
  • Monitored server activity, error logs, space usage, and solved problems as needed
  • Worked with data modelers in logical and physical data modeling; developing E-R Diagrams; implementing and updating the logical and physical data models in databases
  • Assist and work with developers to resolve SQL Server database and related issues
  • Created and maintained logins, users and manage security tasks like granting and revoking permissions for server, database and database objects
  • Document major changes made, problems encountered and solutions for fix to SQL Server

Junior SQL Database Administrator

Confidential

Responsibilities:

  • Installed, Configured, and Managed SQL Server 2000 and 2005 in development, test, and production environments
  • Migrated SQL Server 2000 to 2005
  • Applied applicable MS SQL Server service packs (SPs) on SQL Server 2005
  • Prepared/designed and implemented backup strategy, maintenance and disaster recovery plan
  • Performed regular backups, restores and database refreshes
  • Setup, configured, monitored, troubleshoot and maintained Log Shipping and Database Mirroring
  • Create new database objects like tables, views and procedures using T - SQL
  • Implemented business rules in databases, set up referential integrity to maintain data integrity and other database level constraints
  • Scheduled and maintained jobs on MS SQL Server
  • Performed MS SQL Server performance monitoring and optimization
  • Created user accounts and managed database object permissions
  • Reviewed SQL Server activities, error logs, event logs, disk space management

TECHNICAL SKILLS

  • Databases: MS SQL Server MS Access
  • Reporting and ETL Tools SSRS, SSIS, BCP and SQL Server Import/Export Wizard
  • Development Tools MS Visual Studio Report Builder 3.0/2.0, Eclipse
  • Data Modeling Tools SQL Server Database Diagram(SSDD), Toad Data Modeler and MS VISIO
  • SQL Server Native and other tools SQL Profiler, Activity Monitor, PerfMon, SSMS, Built - in Reports, Scripting Wizard,
  • Execution Plan, Maintenance Plans, Upgrade Advisor, Database Tuning Advisor, Database Mail, SQL Server Agent
  • Error Logs, SQL Server Logs, Windows Event Viewer, and third Party tools for SQL Server
  • Testing Tools Quick Test Professional (QTP) and Quality Center (QC)
  • Operating Systems Windows Server Windows 8, Windows 7, Windows NT 4.0
  • Professional, Widows 2000 Professional, Windows XP Professional and MS-DOS

Hire Now