Senior Database Administrator Resume
VA
SUMMARY:
- 15 years of experience in Web based Applications Internet / Intranet/ Extranet
- 15 years in ColdFusion developing and upgrading applications using ColdFusion
- 15 years of Database Administrator experience.
- JavaScript, SQL Server, IIS, HTML, HTML5, Apache, Oracle 10g, CSS, JQuery, AJAX
- 6+ years in .NET, C#
- Expertise in Web Administration using ColdFusion Administration.
- Expertise in the entire lifecycle of application development
- Experience as Lead Developer
- Expertise in UI creation using Dreamweaver, Adobe CS5
- SharePoint 2007, 2010, 2013
- Workflow tools (Open text)
- Possess extensive knowledge of InfoPath form
- Experience in Bootstrap, Angular, JavaScript
- Expertise in VMware
- Possess knowledge of Team Foundation Server 2012 Configuration management.
- Strong with database design and writing stored procedures (T - SQL).
- Expertise in the databases like SQL Server, MS-Access, Oracle
- Proficient in MSSQL, Oracle 10g, Oracle 11g
- Experience working in APEX
- Expertise in writing SQLs, TSQLS, Stored Procedures and Triggers
- Expertise in backups, restoration, configuration and installation of Microsoft SQL Server
- Expert level SQL Server Database architecture, design and development
- Experience with Power BI
- Experience in SQL Server Integration Services (SSIS)
- Experience working with Remedy
- Strong knowledge of SSRS and Pentaho Reporting
- Experience in Oracle Fusion Middleware.
- Experience in OLAP design (SSAS) and ETL (SSIS)
- Possess extensive knowledge of Maximo architecture and the supporting components. Offer hands-on experience with the development and standardized implementation methodologies
- Have Clear knowledge of the Maximo Schemas and relationships and table structures including Work order, Inventory and Purchasing.
- Expertise in programming knowledge and skills with SQL 2000 DTS packages
- Expertise in user training
- Experience working with several government agencies.
- Active Top Secret Clearance
TECHNICAL SKILLS:
Tools: Eclipse, Macromedia Flash 4, 5, MX, CSS, CS5, Adobe Photoshop, Illustrator, Fireworks
Perforce: GIT, ColdFusion Builder
Rational Clear Case: SharePoint 2010, 2013, Crystal Reports 9, X1, Visual Studio 9, 2010, 2012
Adobe LiveCycle: Microsoft Project, Team Foundation Server, Visio, TOAD
Cold Fusion Reports: Microsoft Share Point Designer, SharePoint Services 3.0, Paintshop Pro, MetaStorm (OpenText)
Report Builder: CommonVault, Golden, Adobe LiveCycle designer Workbench, Visual SourceSafe
Languages: HTML, HTML5, DHTML, XML, ColdFusion MX, 7, 8, 9, 10, 11, CSS, JavaScript, Crystal Reports, Ajax, JQuery, NET, C#, SQL, PL/SQL
Databases: Microsoft SQL Server, SQL, Access, Oracle
Platforms: Windows 98, 2000, 2003, 2008, 2012 NT, XP, UNIX, WebLogic, WebSphere
PROFESSIONAL EXPERIENCE:
Senior Database Administrator
Confidential, VA
Responsibilities:
- Working with DOJ on migrating Legacy Oracle data to SQL Server
- Responsible for Weekly backups of Database.
- Migrating Legacy data from Oracle to SQL Server 12.
- Converting Oracle tables to SQL Server tables.
- Working with business requirements to identify and understand source data systems; provide resolutions to all data issues and coordinate with data analyst to validate all requirements, perform interviews with all users and developers.
- Map source system data to new SQL Server tables
- Develop and perform tests and validate all data flows and prepare all ETL processes according to business requirements and in corporate all business requirements into all design specifications.
- Define and capture metadata and rules associated with ETL processes
- Adapt ETL processes to accommodate changes in source systems and new business user requirements
Senior DBA/Lead ColdFusion Developer
Confidential, VA
Responsibilities:
- Solely responsible for the planning, development, testing, quality assurance and deployment of several classified, standards-compliant, web-based applications using ColdFusion 11 for Department of State.
- Converting code from .NET to ColdFusion of Excel based application.
- Responsible for Project Management.
- Responsible for setting configuration management.
- Responsible for setting development and test environment.
- Installed ColdFusion servers and responsible for security guidelines for ColdFusion server administration
- Installed the latest security patches for windows server 2012.
- Implemented security standards and checklists applicable to enterprise databases and performed DISA STIG for Microsoft SQL Server.
- Technology used: SQL Server, JQuery, ColdFusion 11, CSS, JavaScript, xml, TFS agile, CS6
- SSRS Reporting, Bootstrap, CommVault
Senior Database Administrator
Confidential, VA
Responsibilities:
- Worked for the JSF F-35 Fighter Jets Project
- Responsible for setting up Configuration Management using Team Foundation Server.
- Performed Weekly backups of Database.
- Involved in JAD/ Rad sessions with stakeholders.
- Maintained over a dozen applications.
- Involved in upgrading .NET code from .NET 2.0 to 4.0
- Worked to upgrade SharePoint from 2007 to 2013 environment.
- Designed, developed, tested, and maintained SharePoint applications and Intranet site.
- Created workflow projects.
- Performed database system administration, including: daily checklists, backup verification, log review, security maintenance, performance tuning (analysis, indexing, updating statistics, etc.).
- Created, updated and maintained database objects in coordination with our reporting team.
- Created, reviewed and maintained code in our database systems to optimize, standardize and/or prepare for upgrades.
- Involved in creating, maintaining, updating and troubleshooting of SSIS packages.
- Upgrade, configure and maintain server and database monitoring software to baseline system performance and proactively identify (and remedy) potential issues. Resource monitoring and capacity planning.
- Reviewed, tested, updated and documented detailed disaster recovery/business continuity plans for key production SQL Servers (database mirroring, log shipping, replication, clustering) in a VM/SAN environment.
- SSRS administration, updates, troubleshooting and development.
- Performed database backup and recovery as required, including periodic testing.
- Technology used: Oracle, SQL Server, JQuery, .NET, css, JavaScript, boorstrap,xml, TFS agile, CommVault
Senior lead ColdFusion Developer
Confidential, VA
Responsibilities:
- Responsible for planning, development, maintenance of web application for the EPA.
- Performed Configuration Management.
- Performed System health check.
- Performed daily Backups of Database.
- Involved in JAD/ Rad sessions with stakeholders.
- Technology used: Oracle, Sql Server, JQuery,ColdFusion 9 css, JavaScript, xml, TFS agile,CS5
- SSRS Reporting
Senior Metastorm Developer
Confidential, VA
Responsibilities:
- Worked at National Archives
- Creating reports using Crystal Reports.
- Working to Upgrade from Oracle 10 to 11g
- Upgraded Metastorm, Webserver and Oracle.
- Performing Weekly backups of Database and Webserver.
- Technology used: Oracle, JQuery, Metastorm, css, JavaScript, xml, TFS agile, CS5, VMware, Sql Server
Senior SharePoint Developer
Confidential, VA
Responsibilities:
- Worked on an FBI SharePoint project
- Created reports using SSRS
- Maintained and enhanced .NET applications.
- Working on projects developing and administering solutions in SharePoint that include web parts, database connections, workflow and forms
- Technology used: SharePoint, SQL Server, JQuery, Prototype, CSS, JavaScript, xml, TFS agile,CS5, HTML5,Adobe,Visual Studio 2012, VMware
Senior Developer
Confidential, Rockville, VA
Responsibilities:
- Worked on an FBI SharePoint project
- Upgrading SharePoint from 2007 to 2013
- Created reports using SSRS
- Worked on development and Enhancements for .NET applications.
- Working on projects developing and administering solutions in SharePoint that include web parts, database connections, workflow and InfoPath forms
- Technology used: SharePoint, SQL Server, JQuery, Prototype, css, javascript,yui,html, xml, eclipse, TFS,,agile,CS5, HTML5,Adobe,Visual Studio 2012, VMware
Team Lead /Senior Developer
Confidential, Herndon, VA
Responsibilities:
- Upgraded all ColdFusion servers from 8.0 to 9.01 Upgraded Crystal Reports server from 9 to XI
- Created reports using Crystal Reports 9, XI
- Worked on several development and Enhancements for ColdFusion applications.
- Worked on projects developing and administering solutions in SharePoint that include web parts, database connections, workflow and InfoPath forms
- Created and converted all applications using .NET technology
- Technology used: ColdFusion 8.01,9.01, Oracle 10g, 11g, Jquery, Prototype, css, javascript, yui,html, xml, eclipse, Git,,agile,CS5,Coldfusion builder, Rational, HTML, HTML5,Adobe,Visual Studio
Team Lead /Senior Developer
Confidential, VA
Responsibilities:
- Worked on a DOD project.
- Upgraded all ColdFusion servers from 8.0 to 9.01 then 10
- Worked on the development and enhancements for ColdFusion applications.
- Technology used: ColdFusion 10,Sql Server, 11g, JQuery, Prototype, css, Javascript,yui,html, xml, eclipse, Git,agile,CS5,Coldfusion builder, Rational, HTML, HTML5,Adobe,Notepad++
Team Lead /Senior Developer
Confidential, MD
Responsibilities:
- Metastorm BPM suite 7.5 Developer on .NET platform
- Responsible for taking business requirements documents and converting them into technical specifications.
- Metastorm Designer Maps coding the application to meet those technical specifications.
- Testing of code and conducting reviews of code to meet the business requirements for the application.
- Troubleshooting the current production environment where defects have been identified and corrected those.
- Supporting QA in their testing efforts of the application.
- Business process analysis and requirements definition utilizing process modeling methodologies.
- SharePoint developer. Created and managed sites using Web parts, database connections and InfoPath forms for various offices for the State dept.
- Technology used: Metastorm 7.0, Oracle 10g, 11g,, css, JavaScript,, SharePoint, Sql Server
Team Lead, Perot Systems
Confidential, Ft Belvoir, VA
Responsibilities:
- Worked on enhancing ColdFusion applications.
- Upgraded ColdFusion server from MX to 7,8.
- Add security to the websites to protect against sql injection and cross site scripting.
- Work with infrastructure to get the ColdFusion 8 server stable.
- Assist with new projects and help debug old projects.
- Gather information for upcoming projects to assist with requirements
- Work closely with the marketing Group to better improve the visibility and access to our internet sites.
- Focal point of dissemination of information from management and customer to team and vice versa.
- Technology used: ColdFusion 8, SQL Server 2000, 2005, Jquery, css, JavaScript, html, InfoPath, Clear Case, Photoshop, Dreamweaver CS 5.Crystal Reports, Visual Studio, SharePoint designer
Software Developer
Confidential, Herndon, VA
Responsibilities:
- Responsible for the detailed design and implementation of Forms for the SENTINEL Case Management application using Adobe LiveCycle 8.0, XML
- Substantial interaction with the Customer during design and development XML
- Assisted in the gathering of the requirements, analysis of the processes and provide assistance to the users Automate New accounts procedures
- Responsible in the creation of the forms, workflow, integration with databases to pre-populate forms from the database and deployment of forms
- Mentored co-workers on development of complex forms which included workflow, activation of forms on intranet and digital signatures.
- Technology used: Adobe LiveCycle, SQLServer 2000, SQLServer 2005, Jquery, css, javascript,HTML, Crystal reports
Confidential
Database Administrator
Responsibilities:
- T-SQL programming, stored procedures/dts packages, views, functions
- Member of team developing a Web Application used to generate report and track information dealing with various aspects of the US nuclear stockpile
- Involved in the full life cycle development of the project, to include Joint Application Design (JAD) sessions with the users, Rapid Application Deployment (RAD) of the software
- Developed an administrative Application that would provide system administrators with creating user accounts and multiple update capability
- Developed and maintained software and web applications to facilitate the building of an Enterprise Architecture
- Developed the Personnel Information Management System application software, which is a tool to facilitate Cherokee Information Service’s online resume.
- Developed Support Center software using Flash Professional and ColdFusion MX 7 to enable users to report problems and request changes.
- Created and tested several reports using ColdFusion technologies.
- Participated in project roll out, fine-tuning and project maintenance.
- Involved in software installation and training users.
- Technology used: ColdFusion 8, Flash, Flex, Oracle, Prototype, css, JavaScript, html,, Photoshop, Dreamweaver, ColdFusion Report Builder.