We provide IT Staff Augmentation Services!

Senior Engineer Analyst | Senior Sql Dba Resume

SUMMARY:

  • Microsoft Certified SQL Server Database Administrator
  • MongoDB Certified Databasee Administrator
  • 8+ years of experience as a SQL DBA, Well experienced in various aspects of database technology (Administration, Performance Tuning, Security, and HA/DR solutions) and incident handling
  • Worked on MongoDB concepts such as locking, transactions, indexes, Sharding, replication, schema design.
  • Experience in managing MongoDB environment from availability, performance and scalability perspectives.
  • Working knowledge of MySQL and Oracle RDBM systems.

PROFESSIONAL EXPERIENCE:

Confidential

Senior Engineer Analyst | Senior SQL DBA

Responsibilities:

  • Experienced in applying 2016/2014/2012/2008 R2 periodic service packs and hot fixes (cumulative updates).
  • Auditing of databases for user’s transaction, login and database action and fixing orphaned users.
  • Managed users and logins in SQL server, provide appropriate server/database roles, map them to specific databases and grant specific privileges over selected database securable objects to ensure security and integrity.
  • Analyzed and deployed scripts and packages in prod/test environments from different developers based on CR/change request process.
  • Involved in capacity planning and allocation of resources for the databases by assisting application teams in creating databases depending upon the criticality of the databases following current and best practices in accordance with SLA of the different clients.
  • Responsible for capacity planning, forecasting data growth of databases and providing reports on quarterly basis.
  • Responsible for creating and monitoring database maintenance plans and schedule jobs using SQL Agent/Maintenance plan and third party tools; Schedule database integrity check, reorganize/rebuild indexes, update statistics, backup/restore and cleanup job history.
  • Extensively used SQL native tools for performance monitoring /analysis and troubleshooting. by analyzing execution plans, creating and maintaining indexes (rebuild/reorganize).
  • Analyzed Locks, Blocking, Dead Locks, and handling of Isolation Level and Concurrency issues.
  • Reviewed and optimized SQL queries, stored procedures, views and triggers from other developers to achieve maximum efficiency and scalability. Provided consultation for development teams regarding performance review and the correct usage of database objects and list the most resource - intensive queries on the server and suggest ways to improve performance on each.
  • Supported implementation of AlwaysOn, Availability groups by creating availability databases using the high availability and DR strategies in clustered environment.
  • Experienced with configuring database high availability techniques like Replication, clustering as well as implementing disaster recovery techniques like database mirroring and log shipping.
  • Used native tools and third party tools to diagnose server reliability and performance issues.
  • Monitored SQL Server Error Log, Windows Event Logs, Profiler, Query Execution Plan, Database Tuning Advisor, System Monitor, for troubleshooting performance issues.
  • Experienced in implementing, configuring and maintaining Transactional Replication.
  • Run Database Consistency Checks (with DBCC CHECKDB).
  • Configuration of mission-critical databases for HA/DR solution like clustering, currently working in a big environment with multiple clustered environments (2005, 2008, 2012, 2014 and 2016 SQL versions).
  • SQL server monitoring using solar winds monitoring tool.
  • Worked on MongoDB database concepts such as locking, transactions, indexes, Sharding and replication.
  • Experience in managing MongoDB environment from availability, performance and scalability perspectives.
  • Backup/Restoration of Database through Mongodump/mongorestore utility.
  • Index creation and administration for query performance.
  • Creating and managing Capped and TTL collections
  • User Management - creating users, assigning roles, managing permissions.

Confidential, Indianapolis, IN

Senior SQL Engineer

Responsibilities:

  • Upgrade of SQL 2005 to 2012 in a windows Server 2012R2.
  • Responsible to work on any questions, configurations, documentation, implementation, support and day-to day issues with customer’s environment relative to their SQL 2005 Environment.
  • Develops and maintains technical documentation and operational procedures for areas of responsibility including upgrading SQL 2005 to 2012, performany enhancement and maintenance.
  • Prepares and deploys complex schema updates, data migration and ETL scripts.
  • Maintains servers with focus on performance tuning SQL queries,table design, indexing, and query plan analysis
  • Installing, configuring and administering SQL Server 2005 and 2012 instances.
  • Administered MS SQL Server security by creating user and logins with appropriate roles.
  • Implemented maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space).
  • Run DBCC consistency checks and analyze stack traces, if generand fixing data corruption, if arises
  • Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), problem management, Incident management, Security maintenance etc.
  • Collaborated with network operations, application developers and DBAs to enhance end user experience

Confidential, Silver Spring, MD

SQL Server Database Administrator

Responsibilities:

  • Identified SQL statements with poor performance using Performance Tools and SQL Trace tools.
  • Configured performance tuning and optimization in SQL Server 2005, 2008 and 2012.
  • Performed testing on stored procedures, indexes, and triggers.
  • Performed data migration using Bulk Insert, BCP and SSIS, from Flat files to SQL Server 2008/12.
  • Installed, configured, upgraded and monitored SQL Server 2005, 2008R2 and 2012.
  • Implemented and configured Backup and recovery process using maintenance plans for database servers.
  • Involved in In-place SQL server upgrade from 2008 to SQL server 2012.
  • Involved in Day-to-day activities such as Agent Jobs, Backups and Recovery services, Index, Database growth, health and consistency check, Data maintenance (partitioning, archiving and purging), problem management, Incident management, Security maintenance etc.
  • Involved in designing, configuring, monitoring and troubleshooting replication methodologies, log shipping and mirroring on critical databases.
  • Monitored Jobs to make sure all scheduled jobs run successfully every night? Run Database Consistency Checks (DBCC), scheduling the DBCC to run on a daily and weekly basis.
  • Configuration of mission-critical databases for HA/DR solution like clustering and always on availability groups.

Confidential, Raleigh, NC

SQL Server Database Administrator

Responsibilities:

  • Planned, installed, configured and upgraded installations of SQL server 2012.
  • Involved in planning and administration of Failover clustered environment.
  • 24 x 7 on call support as part of a scheduled rotation with other team members.
  • Developed documentation for the various database standards, procedures and policies? Involved in creating packages using Integration Services.
  • Monitored and optimized database and server performance using tuning methodologies and tools, including enterprise manager, query plans, performance views, and other SQL Server tools.
  • Maintained and improved high availability and disaster recovery strategies for the database environments, including backup/restore, where appropriate.
  • Involved in the implementation of databases mirroring and log shipping.
  • Administered SQL Server security at a server, database and object level.
  • Involved in performance tuning for the optimization of slow running queries and index maintenance.
  • Automated SQL Server Agent jobs for Periodic Backups with Backup Devices and Database Maintenance Plan.

Confidential, Atlanta, GA

SQL Server Database Administrator

Responsibilities:

  • Installed, configured and administered SQL Server 2008 instances.
  • Administered MS SQL Server security by creating user logins with appropriate roles.
  • Implemented maintenance plan for MS SQL Server (DBCC, updating index statistics, monitoring database and disk space).
  • Managed the use of disk space, memory and connections.
  • Run DBCC consistency checks and analyzed stack traces, if generated, fixing data corruption.
  • Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T- SQL.
  • Experienced in Performance Tuning and Query Optimization.
  • Responsible for DR/HA policy implementation; Involved in designing, configuring, monitoring and troubleshooting replication methodologies, log shipping and mirroring on critical databases and quickly resolving issues.

Confidential

Jr. SQL Server Database Administrator

Responsibilities:

  • Installed and configured SQL Server 2000/2005 Database Servers.
  • Administered the MS SQL Server security by Creating User Logins with appropriate roles.
  • Responsible for tuning indexes, and queries as well as providing assistance on these areas to development teams. Troubleshoot SQL Server performance issues for internal and external customers.
  • Setup log shipping and troubleshooting log shipping errors when arises.
  • Migrated DB which was done from Access to SQL 2005, and SQL 2000 to 2005; and Troubleshooting performance issues after migration.
  • Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
  • Wrote SQL scripts to create database and database objects.
  • Performed Full Backups, differential and Transactional Log Backups. Restore them whenever necessary; creating back up strategies and scheduling them for execution.
  • Worked with development teams in the design of physical databases and in modifications.
  • Run DBCC consistency checks and fixing data corruption in databases.

Jr. Computer Administrator

Confidential

Responsibilities:

  • Ensuring that the computer systems at the university’s computer centers are kept working in an efficient manner
  • Fixing any issues with software and hardware of computers for the university’s computer systems
  • Maintaining these systems, answering questions, monitoring them and issuing upgrades

Hire Now