Sr. Sql Dba Resume
3.00/5 (Submit Your Rating)
SUMMARY
- My background includes more than 15 years of Microsoft SQL database and Windows Servers administration along with experiences of various applications such as Microsoft SharePoint and Microsoft BizTalk. Over 20 years of IT working experiences with a proven background of technical problem solving. I’m a self - motivated, responsible, and reliable team player with a set of very strong technical skills.
PROFESSIONAL EXPERIENCE
Confidential
Sr. SQL DBA
Responsibilities:
- Configured, Installed, and managed SQL Server 2012, 2014, 2016, 2019 on Windows and Windows Cluster Servers
- Migrated databases from SQL Server 2005/2008 to SQL server 2012, 2014, 2016, 2019
- Provide daily SQL support include backup/restore, access permissions, and any issues that users may have relating to database
- Perform weekly maintenance includes re-organize and rebuild indexes, update statistic, and cleanup history
- Monitoring alerts using tool such as Idera and Dynatrace
- Troubleshoot performance relate to SQL as reported
- Consult with apps owner when installing new SQL server for proper capacity planning
- Familiar and experience with SSRS and SSIS
- Knowledge and understating of Data Warehousing and BI and Postgre SQL
- Knowledge and understand of DevOps tool
- Successfully migrated SQL databases of various apps into Google and Azure cloud
- Manage and support SQL severs in both Google and Azure cloud
- Additional accomplishments: Lead technical and Architect on a couple of projects for setting up SharePoint 2013 and Content Management Server 10.5 (OpenText). And assisted upgrading of a few other apps
- Continue to self-educating and training to stay up to date with changes
- Currently, taking online training courses on AWS cloud service
Confidential
SQL DBA\System Administrator
Responsibilities:
- 7 + years of hands-on installation, configuration, and administration of all SQL servers 2000/2005/2008 Standalone and active/active Cluster Servers environment with NetApp storage
- 12 + years of hands-on implementation, upgrade, and support Windows NT 4.0/2000/2003/2008 Server and Stand-alone
- Database and Application tuning and performance monitoring include creating indexes
- Manage and maintain all SQL database servers while ensuring optimal reliability and uptime
- Database Migration from SQL server 2000 to SQL server 2005 and 2008 active/active Cluster Environment
- Install upgrades, patches, and configurations to keep existing Servers and Applications up to date
- Perform troubleshooting of issues and problems related to database
- Responsible for backing up and restoring data for all database servers
- Responsible for database Replication to Disaster Recovery site using Publications and Subscriptions, Database Mirroring and Log Shipping
- Implemented and Maintained Database Security - Creating users and assigning roles and privileges at Server and Database level
- Experience and familiar with SSIS and SSRS (Build reports using SSRS and created Maintenance jobs Extract/Load data with SSIS)
- Work with developers on various projects include database design, future growth, and changes
- Additional responsibility. Installation, configuration, and administration of MS SharePoint 2007 and MS BizTalk 2006 and 2009 servers
- Manage over 40 Windows Servers (Servers 2003 x32/x64 and Servers 2008 x32/x64) includes MS SQL, Web, SharePoint, and BizTalk
- Familiar and use of Active Directory and general understanding of Group Policy
- Familiar and understanding of NetApp SAN technology
Confidential
Access Management/Security Analyst
Responsibilities:
- Setup/Maintain NT, SAP, Exchange accounts using ADUC
- Implement and maintain database security (create and maintain users and roles, assign privileges)
- Setup/Maintain distribution lists, custom recipients, generic mailboxes, global groups, and new files share
- Provide support to other Network Administrators in different cities
Confidential
Network/Exchange Administrator
Responsibilities:
- Responsible for all network related issues that include LAN, WAN, Routers, Switches, network connectivity
- Configured Citrix server and troubleshoot all Citrix issues
- Install and configure File and SQL servers
- Maintain company e-mail (Exchange 5.5) which include installation, configuration, migrate mailboxes, setup new accounts for new users