Dba (data Base Administrator) Resume Profile
4.00/5 (Submit Your Rating)
Washington, DC
OBJECTIVE Looking for SQL Database Administrator position
COMPUTER SKILLS
Microsoft SQL server 2005, 2008, r2 and 2012, SQL Database, Share point, Microsoft Office plus windows, Microsoft Excel, Access, Word, power point, system trouble shooting, SSIS, SSRS
WORKING EXPERIENCE
Confidential
DBA Data Base Administrator
- Designed, development and administration of MS SQL Server databases
- Handled Performance monitoring, reporting, and tuning of MS SQL Server databases
- Managed maintenance of back-ups recovery procedures
- Installed and maintained MS SQL Server databases
- Managed security and access control for MS SQL Server databases
- Ensured all database servers are backed up in a way that meets the business's Recovery Point Objectives RPO
- Tested backups to ensure the company meet the business' Recovery Time Objectives RTO
- Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
- Configured SQL server monitoring utilities to minimize false alarms
- Installed and configured new SQL Servers
- As new systems are brought in-house, chose whether to use clustering, log shipping, mirroring, windows, Azure, or other technologies
- Prepared daily report on the job failures, backup failures and disk space.
- Extensively used Database Performance Monitoring tools for performance tuning.
- Designed and implemented database maintenance plan.
- Used Index tuning wizard and rebuilding indexes for faster Query Performance.
- Involved in resolving dead lock issues and performance issues.
- Good knowledge about New features in SQL server 2012
Confidential
Data Analyst
- Analyzing hospital discharge data in the database system
- Reviewing applications for CON Certificate of Needs and log them in using the database management system
- Research and the identification of key data sources
- Converting the file system to computerized data base system
- Perform analyses, review research conducted and information received from various locations
- Write reports in a clear and concise manner that summarize the information gathered and identified during research
- Expert on Microsoft Excel and Access
Confidential
SQL Server DBA
- Administered database backup recovery process
- Highly proficient in database Backup, Restore, Recovery, Linked servers, and Database Maintenance Plans.
- Experience on High Availability and Disaster Recovery like Replication, Log shipping, Mirroring and Clustering and database security and permissions
- Created Security by setting up groups and then logins for each Roles or Users for Maintenance of Databases.
- Documented Disaster recovery plans and participated in disaster recovery drills.
- Successfully tested and implemented Log Shipping technique used for warm backup solution for MSSQL server2000/2005/2008 databases.
- Expert in developing T-SQL DDL, DML, DCL statements.
- Proficient in implementing different types of Replication models like Snapshot, Transactional, Merge and Peer-Peer.
- Experience in Implementing Database Mirroring in SQL server 2005/2008.
- Involved in Installing, Configuring and Maintaining of Cluster in SQL Server 2008 and SQL Server 2005 in Active/Passive.
- Hands on experience in writing and debugging Stored Procedures, Triggers, Cursors, Complex queries using T-SQL Scripts and Batch files
Confidential
Financial Aid office Assistant
- Organized and maintained student files database
- Answered and directed phone calls appropriately
- Answered students' Question about their financial aid status
- Type correspondence, reports and other documents
- Maintained confidential records and files using computerized database management system
- Prepared documents and reports using various computer applications
Confidential
System Administrator
- Maintained back up files and ensured proper recovery steps are in place
- Managed security and access control for Server databases
- Run and take backups for every day's transactions
- Maintained and monitored the bank's database system
- Served as a librarian to keep all the backup files and system recovery documentations
- Trouble shooting with regard to system, monitored the networking flow
- Run various types of reports to the users
- Administered Database Management System