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.