LiveCareer-Resume

certified it administrator database resume example with 12+ years of experience

Jessica Claire
  • Montgomery Street, San Francisco, CA 94105 609 Johnson Ave., 49204, Tulsa, OK
  • Home: (555) 432-1000
  • Cell:
  • resumesample@example.com
Professional Summary
  • 9+ years of extensive experience in database design, development and administration with MS SQL Server 2017/2016/2014/2012/2008/2005 using SSIS, SSAS, SSRS in financial, retail, healthcare and banking industries.
  • Highly experienced in Database Designing, Implementation and System Administration using Microsoft SQL Server as well as Windows 2003, 2008 & 2012
  • Hands on experience on deploying Cloud based SQL environments in AWS and AZURE
  • Experience using Performance Monitor/Profiler to troubleshoot Dead Locks, long running queries.
  • Extensively used the native tools like Index Tuning Wizard, Database Tuning Advisor, Profiler, Performance Monitor, Activity Monitor, and Event Viewer for performance analysis.
  • Experience in Data Migration by using side-by-side upgrade process Management.
  • Experience in implementing SQL Server security and Object permissions.
  • Experience in creating and managing database objects like tables, views, stored procedures, Triggers, user defined data types and functions.
  • Expertise in implementing and maintaining efficient Disaster Recovery Strategies and High availability like Always On, Replication (Snapshot and Transactional with uneatable subscriptions), Log shipping, Clustering (Active-Active and Active Passive)
  • Experience with Database consistency checks using DBCC & Dynamic Management Views (DMVS)
  • Experience in troubleshooting SQL issues by using SQL Tools Execution plan, Trace, DTA.
  • Have experience in Performance Tuning, T-SQL Query Optimization and resolving Blocking issues.
  • Expertise in Identifying the Bottlenecks caused by complex queries using Activity Monitor/SQL Profiler and handling them by implementing better Query Execution plans.
  • Experience in ETL between Homogenous and Heterogeneous System (Oracle/DB2/Access/Excel/CSV/XML) using SQL tools (SSIS, DTS, Bulk Insert, BCP) and providing a definite solution.
  • Experience in creating several Master-Child reports (drill-down, matrix, tabular, linked, sub-report) model for Monthly/Quarterly client reporting system on SSRS Crystal reports.
  • Knowledge of SQL Server Database Administration tasks such as planning, scheduling jobs, backup and recovery strategies, index tuning and performance tuning, and archiving data.
  • Experience in monitoring SQL server, capturing performance problem and improve performance by tuning Databases.
  • Experience in creating and maintaining Backup and Restore, Mirroring and Log-Shipping strategy as a part of Disaster recovery.
  • Excellent in Capacity Planning and storage management.
  • Excellent analytical and communication skills with 24/7 rotated support experience.
Skills
  • MS SQL Server 2000/2005/2008/2012/2014/2016 , MongoDB & Maria DB
  • Language: T-SQL, PL/SQL,
  • Server: Windows Server 2000/2003/2008/2012,
  • DB Tools: Quest Fog light, Spotlight, Lite Speed (Backup Tools), SQL native Monitoring tools, NT Performance monitor/System monitor, TSQL, SQL Profiler and SQL Query Analyzer
  • Reporting Tools Crystal Reports, BID, SQL Server Report Builder, Visual Studio
  • Data Migration MSDTS, SSIS, ETL, BCP, Data Migration, Import/Export Wizard, SSMA
  • NYC Dept. of Education
  • Database Administrator
  • NET, Migration, Microsoft Visual studio
  • Administrative, Enterprise, XML
  • ADO, Network
  • Ad, Optimization
  • Automate, DB
  • Backup, Developer
  • BizTalk, PL/SQL
  • Capacity planning, Policies
  • Clustering, Coding
  • CPU, QA
  • Encryption, QUEST
  • Crystal Reports, Read
  • Client, Reporting
  • Data management, Scheduling
  • Data Migration, Servers
  • DTS, Scripts
  • Data warehouse, Shipping
  • Database, MSSQL
  • Databases, MS SQL
  • Debugging, MS SQL Server
  • Disaster Recovery, SQL
  • Editing, SQL Server
  • ETL, Statistics
  • Fashion, Sybase
  • Features, Tables
  • IIS, Teradata
  • Memory, TSQL
  • Microsoft Certified Professional, T-SQL
  • Microsoft Certified, Troubleshooting
  • Windows, Upgrade
  • 2000, Utilities
  • NT, Visual Studio
  • Data structures knowledge
  • Database development
  • Implementing security measures
  • Microsoft .NET framework
  • Linux operating system
  • Microsoft Visual C#.NET
  • Ubuntu
  • Systems administration
  • Relational Database Management
  • NET, Microsoft .NET, Administrative, ADO, Ad, Automate, Backup, BizTalk, Capacity planning, Clustering, CPU, Encryption, Crystal Reports, Client, Data management, Data Migration, DTS, Data warehouse, Database, Databases, Database development, Debugging, Disaster Recovery, Editing, ETL, Fashion, Features, IIS, Linux, Memory, Microsoft Certified Professional, Microsoft Certified, Microsoft Visual C, Windows, 2000, NT, Migration, Enterprise, Network, Operating system, Optimization, DB, Developer, PL/SQL, Policies, Coding, QA, QUEST, Read, Relational Database, Reporting, Scheduling, Servers, Scripts, Shipping, MSSQL, MS SQL, MS SQL Server, SQL, SQL Server, Statistics, Sybase, Systems administration, Tables, Teradata, TSQL, T-SQL, Troubleshooting, Upgrade, Utilities, Visual Studio, Microsoft Visual studio, XML
Work History
Certified IT Administrator (Database), 04/2019 to Current
Bae SystemsWashington, DC,
  • Installation & configuration SQL Servers 2008/2012/2014/2016 and 2017 technology.
  • Fashion & maintain various SQL Databases.
  • Responsible for high availability SQL Server solutions with SQL Server Failover Clustering.
  • Responsible for Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
  • Responsible for Database and Log Backup & Restoration Process, Backup Strategies and Scheduling Backups.
  • Responsible for Security Administration- creating users and assigning them roles and privileges.
  • Maintaining both DEV/UAT and PRODUCTION Servers in sync.
  • Installed and reviewed SQL server patches as well As service packs.
  • Table/index partitioning and full text search and tuning the Production server to get the performance improvement.
  • Creating Backup strategies and scheduling using third party tool like Lite Speed, as a part of database Maintenance plans.
  • Monitoring SQL servers for performance ad-hoc and pro-actively.
  • Providing 24/7 supports to SQL application developers in implementing the applications on production server.
  • SQL Server upgrade and migration to SQL 2017.
  • Installing and configuring MS SQL Cluster Servers in Active/Passive and Active/Active environment.
  • Proactively monitor the Production Server and optimize stored procedures for better performance Resolve locking conflicts and resource utilization.
  • Configured the linked servers on the production and training instances to retrieve data from multiple instances which had legacy data.
  • Migrated DTS packages from the development server to the production server and migrated the DTS packages to SSIS packages.
  • MongoDB implementation and management with Automate MongoDB deployment and data management.
  • Azure SQL Server DB instance management and Implement Azure object store for archival purpose.
Database Analyst, 03/2017 to 04/2019
Pinnacle Technical Resources IncPittsburgh, PA,
  • Fashion and maintain various databases for Production, and in Installation, Configuration and up Gradation of SQL Server 2008R2/2012/2014/2016 technology, service packs and hot fixes using MS SQL Server 2008/2012/2014.
  • Responsible and knowledge of high availability SQL Server solutions with SQL Server Failover Clustering, Always on High Availability Group, Database Mirroring and Log shipping.
  • Responsible for Capacity planning, Performance Tuning, Disaster Recovery, Troubleshooting, backup and restore procedures.
  • Solid hands on performance monitoring with Activity monitor, SQL Profiler, Performance monitor, Database Tuning Advisor, DMVs and DMFs, SQL Diagnostic Manager.
  • Extract, Transform, and Load data (ETL) from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
  • Responsible for Database and Log Backup & Restoration Process, Backup Strategies and Scheduling Backups.
  • Responsible for Security Administration- creating users and assigning them roles and privileges.
  • Migrating contents from SQL server 2008 /2008R2 to SQL Server 2014 using migration wizard.
  • Performance tuning of Queries and Stored Procedures using graphical execution plan, Query analyzer, monitor performance using SQL Server Profiler and Database Engine Tuning Advisor.
  • Experience in configuration of Report Server, Report Manager, Report scheduling, give permissions to different level of users in SSRS 2016/2012/2008/2008R2.
  • Use of DBCC and DMV Utilities to maintain the consistency and integrity of each database in the production server.
  • Conducted root cause analysis of application availability and narrow down the issues related to coding practices, Database Bottlenecks, or Network Latency.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data-to-data warehouse databases and process SSAS cubes.
  • Experience in table/index partitioning and full text search and tuning the Production server to get the performance improvement.
  • Maintaining both DEV/UAT and PRODUCTION Servers in sync.
  • Installed and reviewed SQL server patches as well as service packs.
  • Creating Backup strategies and scheduling using third party tool like Lite Speed, as a part of database maintenance plans.
  • Created the MS SSIS packages for executing the required tasks.
  • Created the Jobs and scheduled for daily running.
  • Design and configure Database, tables, indexes, store procedures, functions and triggers.
  • Troubleshot database status, performance, Replication, Log-shipping as well as various errors on production, development and UAT servers.
  • Experienced in Point-in-time restoring databases in production and development servers.
  • Migrate DTS and SSIS to import and export the data from SQL Servers.
  • Monitoring SQL servers for performance ad-hoc and pro-actively.
  • Providing 24/7 supports to SQL application developers in implementing the applications on production server.
  • Environments: SQL Server2012/2014 (SSMS, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, Visual Studio, Spotlight, Fog-light, Lite speed, TFS, Remedy).
SQL server DBA, 01/2013 to 03/2017
SentryClifton Park, NY,
  • Used Embarcadero DB Artisan for intuitive SQL editing and debugging.
  • Worked with the optimization tools to create high performance SQL code.
  • Designed and implemented comprehensive Backup plan and disaster recovery strategies.
  • Managed over 80 Servers with hosting the high-volume databases sizes up to 3.00 TB.
  • Migrated DTS packages from the development server to the production server and migrated the DTS packages to SSIS packages.
  • Experience in Transparent Data Encryption (TDE) to encrypt an entire database for Security.
  • Experience with Visual Studio 2015 using Team Foundation Server.
  • Install & configured the SQL Server for Team Foundation Server as well as Report Server.
  • Configured & support the enterprise application definition for Team Foundation Server.
  • Configured application builds and automated deployments using the TFS Build and Release features, such as Release Management Client for Visual Studio 2013.
  • Deployed and administered nearly 80 SQL 2005/2008/2008R2/2012 /2014 /2016 servers on 64-bit/32-bit environment.
  • Has migrated stored procedures, functions, triggers, database schema (DDL), BTEQ scripts from Teradata to SQL Server 2008/2008R2.
  • Used Performance Monitor and SQL Server Profiler (ran Trace) to optimize long running queries and thereby improved the performance of the queries.
  • Monitoring SQL server performance using profiler to find performance and dead locks and blockings.
  • Experience in Installing and configuring MS SQL Cluster Servers in Active/Passive and Active/Active environment.
  • Proactively monitor the Production Server and optimize stored procedures for better performance Resolve locking conflicts and resource utilization.
  • Hands on experience in understanding of BizTalk architecture and supporting the behavior of BizTalk Server Host Instances during SQL Server Failover.
  • Has started, stopped, paused, resumed and restarted the BizTalk Server Services.
  • Used QUEST FOGLIGHT to monitor, diagnose and resolve issues database performance issues for highly mission critical SQL instances.
  • Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
  • Identifying & improving server performance using Performance monitor using I/O, memory and CPU counters.
  • Performed End-to-End SQL Server administrative tasks ranging from installing and configuring servers to setup and administer clusters, replication, log shipping etc.
  • Designed, created and maintained databases in both development and production environment.
  • Installed and configured SQL Server 2014/2012/2008R2 and 2005 with Service Packs as per the Business Requirements in UAT, Development & Production environments.
  • Creating, Monitoring and Troubleshooting Maintenance Plans for checking database integrity, rebuilding indexes and updating statistics.
  • Worked on the TEMPDB performance issues, monitored and troubleshooting the TEMPDB database on a regular basis.
  • Monitoring the event viewer and IIS logs for errors.
  • Configured the linked servers on the production and training instances to retrieve data from multiple instances which had legacy data.
  • Operational support for SQL Server Report services (SSRS) by creating the data sources for the appropriate databases.
  • Designed the databases for the reporting functionality of the reporting team.
  • Evaluated data storage considerations to store databases and transaction logs.
  • Developed and implemented Replication, Archiving, Backup and Recovery strategies.
  • Tuned, monitored, maintained & Scheduled SQL Server & BizTalk server Jobs.
  • Provided 24/7 production support on a rotating roster schedule.
  • Worked on BCP Import and Export utility for transferring data.
  • Routine tasks but not limited to: Monitoring and Maintaining the security, integrity and availability of Servers, performance tuning, building packages, responding to users and developer issues and monitoring database backups.
  • Environments: SQL Server (SQL Server Management Studio, DB Artisan, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, Visual Studio, BizTalk Server, Fog light, Sybase, TFS).
Database Administrator, 05/2010 to 12/2012
CAPITAL ONECity, STATE,
  • Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2008.
  • Extract, Transform, and Load data (ETL) from heterogeneous data sources to SQL Server using SQL Server Integration Services (SSIS) Packages.
  • Responsible for Database and Log Backup & Restoration Process, Backup Strategies and Scheduling Backups.
  • Responsible for Security Administration- creating users and assigning them roles and privileges.
  • Migrating contents from SQL server 2005/2008 to SQL Server 2008 R2 using migration wizard.
  • Performance tuning of Queries and Stored Procedures using graphical execution plan, Query analyzer, monitor performance using SQL Server Profiler and Database Engine Tuning Advisor.
  • Implemented transactional replication between Primary Server and Read Only servers.
  • Experience in configuration of Report Server, Report Manager, Report scheduling, give permissions to different level of users in SSRS 2008/2008R2/2005.
  • Use of DBCC Utilities to maintain the consistency and integrity of each database in the production server.
  • Conducted root cause analysis of application availability and narrow down the issues related to coding practices, Database Bottlenecks, or Network Latency.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data-to-data warehouse databases and process SSAS cubes.
  • Experience in table/index partitioning and full text search and tuning the Production server to get the performance improvement.
  • Maintaining both DEV/QA/Test and PRODUCTION Servers in sync.
  • Installed and reviewed SQL server patches as well as service packs.
  • Creating Backup strategies and scheduling using third party tool like Lite Speed, as a part of database maintenance plans.
  • Created the MS SSIS packages for executing the required tasks.
  • Created the Jobs and scheduled for daily running.
  • Design and configure Database, tables, indexes, store procedures, functions and triggers.
  • Troubleshot database status, performance, Replication, Log-shipping as well as various errors on production, development and UAT servers.
  • Experienced in Point-in-time restoring databases in production and development servers.
  • Migrate DTS and SSIS to import and export the data from SQL Servers.
  • Monitoring SQL servers for performance ad-hoc and pro-actively.
  • Design and implement T-SQL Scripts and Stored Procedures and tune up them.
  • Providing 24/7 supports to SQL application developers in implementing the applications on production server.
  • Environments: SQL Server 2012(SQL Server Management Studio, Query Analyzer, SQL Profiler, Index Tuning Wizard, SSIS, MSSQL Server 2012 Analysis Server), Microsoft Visual studio 2012 MS-Reporting Services, ADO.NET, XML.
Education
Bachelor of Science: Computer Science & Engineering, Expected in 02/2010
Royal University of Dhaka - Dhaka,
GPA:
Certifications
MCITP: Microsoft Certified IT Professional MCTS: Microsoft Certified Technology Specialist Microsoft Technology Associate: Database Fundamentals Microsoft Certified Professional

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

Your data is safe with us

Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.

Resume Overview

School Attended

  • Royal University of Dhaka

Job Titles Held:

  • Certified IT Administrator (Database)
  • Database Analyst
  • SQL server DBA
  • Database Administrator

Degrees

  • Bachelor of Science

By clicking Customize This Resume, you agree to our Terms of Use and Privacy Policy

*As seen in:As seen in: