We provide IT Staff Augmentation Services!

Database Administrator Ii Resume

4.00/5 (Submit Your Rating)

Atlanta, GeorgiA

SUMMARY

  • Self - motivated, service-oriented SQL Server Database Administrator. Excellent analytical, organizational, critical thinking, decision making, and problem-solving skills.
  • Able to work independently and as part of a team. Strong determination and commitment to the deliverables. MS in Mechanical Engineering.
  • Microsoft Windows Server 2008 R2, 2012, and 2016.
  • Microsoft SQL Server 2005, 2008, 2008 R2, 2012, 2014, 2016, 2017, and 2019.
  • SQL Server Integration Services (SSIS); clustering, mirroring, and high availability solutions in OLTP environments.
  • SQL Server administration including installation, patching, upgrades, configuration, security, capacity planning, performance tuning, index maintenance, consolidation, backup, and disaster recovery.
  • Manage the production and development of databases including performance tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
  • Providing report by using SSRS, SSIS management tools
  • Virtualization and installation of Windows Server on VMware; managing SQL databases in a virtual environment.
  • Work with developers to identify, debug, and fine-tune stored procedures, T-SQL queries, etc.
  • Manage users including creation, alteration, grant of system, DB roles and permissions on database objects.
  • High availability of database servers using database mirroring, replications, log shipping (BCR; backup, copy, restore), failover cluster, and “AlwaysOn” availability group.
  • Modify stored procedures, queries, views, indexes, and functions for business rules, history, and audit analysis.
  • Use SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
  • Perform routine backup and recovery testing and document recovery scenarios.
  • Import and export data to and from database servers - including bulk loading.
  • Architect and implement SQL Server databases for mission-critical business.
  • Environment transition planning (development, test, stage, production).

PROFESSIONAL EXPERIENCE

Confidential | Atlanta, Georgia

Database Administrator II

Responsibilities:

  • Administered and maintained 150+ database servers in an office, production, and testing environment.
  • Analyzed the current database environment to determine recommend Microsoft SQL Server database maintenance, security, and best practices. Completed database administration maintenance projects.
  • Monitored and troubleshot production environments using IDERA SQL Diagnostic Manager.
  • Created and maintained documentation for DBA standard operating procedures.
  • Ensured all code changes made in the production environment were SOX compliant before they were deployed.
  • Analyzed and migrated data using ETL into SQL Server databases to support customer implementations.
  • Worked closely with infrastructure team for patching and hardware upgrades; ensured both production and test servers were up-to-date by applying Windows and SQL Server patches.
  • Upgraded servers as required from SQL Server to 2017.
  • Coordinated and configured new nodes for production server clusters for high availability.
  • Periodically restored backup files in test environment to check for corruption.
  • Reviewed security, performance, and disk space and recommended corrective actions where needed.
  • Created and executed a migration / decommissioning plan for 500+ databases within a four-month window.
  • Assisted application team in the creation of databases, construction of queries, modification of database tables, and troubleshooting of data issues. Provided 24/7 on-call support as needed.
  • Monitored servers for resource utilization (disk space, memory, CPU, etc.).

Confidential | Lagos, Nigeria

Database Administrator » MS SQL Server

Responsibilities:

  • Created, administered, and maintained SQL Server Databases (production, development, test, and staging environment) for various groups such as QA, developers, and users.
  • Upgraded databases from SQL Server 2005 to SQL Server 2008R2 and 2012.
  • Installed and configured multiple SQL Server instances in production environment.
  • Proactively monitored the database systems to ensure secure services with minimum downtime.
  • Performed database upgrades and applied software patches according application and client requirements.
  • Rebuilt and reorganized the table indexes at regular intervals for better performance.
  • Engaged in disaster recovery (DR) strategic planning and implementation in SQL Server.
  • Created jobs, alerts, and SQL Mail Agents.
  • Set up High Availability (HA) solutions like log shipping, database mirroring, and clustering as a part of DR.
  • Scheduled full and transactional log backups for the user created and system databases in the production environment using the database maintenance plan wizard.
  • Assigned proper user access and security via permissions to the various database objects such as tables, views, and stored procedures.
  • Implemented MS SQL Cluster (active / passive and active / active), Multi Node Cluster for high availability.
  • Rewrote and fine-tuned SQL queries to reduce execution times, ease database loads, and improve scalability.
  • Checked database consistency and health by using DBCC Commands and DMVs at regular intervals.
  • Tested and implemented procedures to detect poor database performance, collected required information, and performed root cause analyses.
  • Analyzed slow queries and fine-tune the same to optimize application and system performance.
  • Monitored and modified performance using execution plans and index tuning.

Confidential | Lagos, Nigeria

SQL Database Administrator

Responsibilities:

  • Configured and administered Microsoft SQL Server 2000 and 2005 for 50 database servers, and 400+ databases.
  • Set up and administered SQL Server database security environments using profiles, database privileges, and roles.
  • Performed DBA activities like analysis of space availability, backups (transaction logs), and scheduled jobs.
  • Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and SQL code.
  • Performed various data migration tasks for mission critical databases.
  • Worked with a team of six to manage 2000+ databases ranging from 350GB to 2.3TB.
  • Worked with PowerShell for performance enhancement and security audits.
  • Implemented security policy design for current and new applications to prevent data corruption and theft.
  • Assisted in establishing standards and schedules for database backups by making sure that the backup schedules met the recovery requirements on a daily, weekly, and monthly basis.
  • Oversaw the design and implementation of new applications and changes to existing hardware systems and software packages for customers for high performance.
  • Used problem-solving skills and root cause analysis to resolve and/or mitigate IT operational issues.
  • Setup and configured database mirroring in high performance, high availability mode as standard DR strategy.
  • Monitored performance and allocated resources to achieve optimum database performance.
  • Monitored and modified performance using execution plans and index tuning.
  • Rebuilt and reorganized indexes at regular intervals for better performance.
  • Set up and scheduled various tasks by creating maintenance plans.
  • Imported and exported data (development to QA to production).
  • Implemented log shipping and transactional replication.

We'd love your feedback!