Sql Server Database Administrator Resume
Reston, VA
SUMMARY:
- To obtain a challenging and rewarding position in IT based firm as Database administrator, Web developer, System Administrator, and related fields, where I can apply knowledge and experience, while being offered an opportunity for professional growth and advancement.
- I have over 12 years of experience in IT as Microsoft System Admin, Database and Website developer, administrator and maintenance
- Fully versed in designing, developing, and managing different databases; back - up and recovery, migration, testing, debugging, resolving Database issues and scripting Windows Batch and PowerShell. In Addition, I have Experience in different programming languages
- Expert knowledge with CMS-driven applications such as Drupal, Sitecore, WordPress and Joomla
- Experienced in sever-level administration and CMS-driven sites
- Experienced in managing web server using various web-based applications such as JavaScript, PHP, .NET, HTML/HTML5, CSS, and AJAX.
TECHNICAL SKILLS INCLUDE:
Database Systems: SQL Server (2000, 2005, 2008,2012,2014,2016), Oracle Database (9i, 10g, 11g,12c), MySQL
P rogramming Languages: C, C++, C#, Java, ASP.NET, PHP, Visual Basic
Web programming: Java Script, HTML, XML, Dreamweaver, FrontPage, .NET, CMS (Drupal, SiteCore, WordPress, Joomla), SharePoint, BizTalk and NETIQ
Web-browsers: Internet explorer, Firefox, Safari, Google chrome
System admin: experience working in Windows, Linux/UNIX, MAC environment have experience as a Microsoft Systems Administrator, Microsoft Cloud (Azure),L Linux Systems, and have experience working with SharePoint, 2016
PROFESSIONAL EXPERIENCE:
Confidential, Reston, VA
SQL Server Database Administrator
Responsibilities:
- As SQL DBA, performed activities associated with Database Administrator such as examining the design of existing database in local and Amazon Web Service (AWS) Environment, wrote SQL procedure and T-SQL scripts to generate required reports
- Analyzed Database performance issue using tools such as SQL profiler and Database Engine Tuning advisor and delivered Solutions that enhanced the performance of the databases, analyzed helped the developer in examining slow queries problems
- Involved and helped in Data migration Process
Confidential, McLean, VA
SQL Server Database Administrator
Responsibilities:
- Performed all activities associated with Database Administrator for the Confidential which include installing and configuring SQL Server 2014; Monitoring SQL server, Tracing SQL Server Activity
- Managing SQL Server Security by granting and revoking access privileges to Database users.
- In addition to managing the database, involved in Database design and creation process of different databases, tables, using SQL Server 2014 for other Confidential projects.
- Played a leading role in Data Migration Project, installed and configured SQL Server Migration Assistant (SSMA) tool to performing Data migration
- Migrated large volume of Data from Oracle 11g to SQL Server 2014 and Azure.
- Performed several Database backups and Restores with in Database Server and between different Servers.
- Performed Data Import and Export using SQL Server 2014 Import and Export Wizards.
- Also, installed, configured, and used SQL Server Integration Services (SSIS) for SQL Server 2014 data migration.
- Also, prepared two documentations and Strategic Plan for the Data Migration Project.
Confidential, Washington, DC
SQL Server Database Administrator
Responsibilities:
- Performed all activities associated with database Administrator for the Confidential which include Installing and configuring SQL Server 2008R2 and 2014, Planning and implementing backup, Restoring Database from Backup, Importing and Exporting Data from the database
- Monitoring SQL server Tracing SQL Server Activity, Managing SQL Server Security.
- In addition to managing the database, have created different databases, tables, forms using SQL Server 2008, and MS Access. Below are some of activities performed:
- Install and configure SQL Server 2008R2//2014
- Configure SQL server Database and storage
- Plan and implement backup Strategy
- Restore Database from Backup
- Import and Export Data
- Monitor SQL server
- Trace SQL server Activity
- Manage SQL Server Security
- Audit Data access and data encryption
- Performed ongoing Database maintenance
- Performed Reporting Services (SSRS)
- Performed Data Integration Services (SSIS)
- Performed Data analysis using Data analysis tools such as (SSAS)
- Automated SQL Server Maintenance with SQL Server Agent Jobs
- Configured Database Mail, Alerts and Notifications
- Designed tools to assist in the management of the database environment.
- Support BOE staff in the effective utilization of database
- Proactively participate in the ongoing Database and other IT Projects that meet the needs of users
- Delivered new functionality and change requests for existing Database in a fast and efficient manner.
- Developed and executed methodology for the ongoing assessment of database performance.
- Prepare strategic plan for the Data Service Department of Confidential
- Involved in several decision making processes, meetings and workshop
Confidential, Washington, DC
Database Developer
Responsibilities:
- Developed new, optimized, SQL (e.g. stored procedures).
- Enhanced existing SQL for new features and/or performance.
- Analyzed data to find inconsistencies.
- Participated in in several database design Processes
- Used Design tools such as Erwin Data Model.
- Support college of Pharmacy staff and faculty in the effective utilization of database and website
- Proactively participated in the ongoing development of applications that meet the needs of users
- Delivered new functionality and change requests for existing applications in a fast and efficient manner.
- Developed and executed methodology for the ongoing assessment of database performance.
- Developed Website applications using Site core, Dreamweaver, PHP, Java script & other tools
Confidential, Washington, DC
Technician/System Admin
Responsibilities:
- Installed and configured SQL Server 2005,2008 in test, development, and production environment
- Installed and configured operating system, windows (XP, vista,7, 8, Windows Server ( &,2008) Enterprise Edition
- Upgraded SQL Server in test and production environment developed front-end and server end applications using HTML, PHP, JavaScript, and, ASP.NET.
- Created web site and developed links for the library E-Journals projects.
- Assisted with the Library’s Digitalization project of Global Health Initiative and converted 500 different manuscripts to digital format compatible with the database in use;
- Assisted in the management of computer systems, troubleshoot problems and install hardware and software.
- Assisted in Providing Information Services to Confidential University Students, Faculty and staff
- Set up Security System for the library Security Desk
- Involved in Different Committee of the Library
Confidential
Instructor
Responsibilities:
- Served as instructor in the Computer Science department and also Served as Vice-chairman
- Taught major courses such as Information Communication Technology, System Analysis & Design, Web Design & Development, and Fundamentals of Computer Science
- Participated in the University’s Curriculum Developing Team.
- Developed database system using SQL server 2000 to track curriculum offerings
- Played a Leading role in team that created the University website using HTML and PHP.
Confidential
Department Head
Responsibilities:
- Served as chairman of Information Science department.
- Coordinated resources, provided student advisory services, participated in the academic committee to design curriculum, and taught Information Science courses including Introduction to ICT, System Analysis and Design, Information Systems and Services, internet, and Web Design