CAREER SUMMARY:

• Experience in information technology field and databases.
• Experience in several government contracts
• Development and design of data.
• High customer interaction
• Supervision of a small team.
• Received awards and recognition for outstanding support for the U.S. Visits project and EIS MDI rollout project.
• Obtain TS/SCI with full scope polygraph

IT SKILLS:

Languages: SQL, PL/SQL, SQLPLUS

Database Systems: Oracle 8i, 9i, 10g, 11g, 12c, SQL Server 2008 R2, 2012, ACCESS, RAC

Operating Systems: Windows, UNIX, Solaris, Linux

Applications: Enterprise Manager, Toad, SQL Developer, Red Gate, Visual Studio, Reflection, Developer 2000, Microsoft Office, Microsoft PowerPoint, ERWIN, HighView, Crystal Reports, Lotus 1 - 2-3, Lotus Notes, Visio, Mac Draw, Telnet, VI editor, Remedy, Cornhill, PitBull

Hardware: PC Compatible, PDP 11/44, SPARC, Sun 4/260

PROFESSIONAL EXPERIENCE:

Confidential

Database Architect/DBA

Responsibilities:

• Determined SQL Server database structural requirements by analyzing client operations, applications, and programming; reviewing objectives with clients; evaluating current systems;
• Developed SQL Server database solutions by designing proposed system; defining database physical structure and functional capabilities, security, back-up, and recovery specifications.
• Installed database systems by developing Entity Relationship diagrams ; applying optimum access techniques; coordinating installation actions; documents actions.
• Maintained database performance by identifying and resolving production and application development problems; calculating optimum values for parameters; evaluating, integrating, and installing new releases; completing maintenance; answering user questions.
• Prepared users by conducting training.
• Provided database support by coding utilities, responding to user questions, and resolving problems.
• Updated job knowledge by participating in educational opportunities; reading professional publications; maintaining personal networks; participating in professional organizations.
• Accomplished information systems and organization mission by completing related results as needed.

Confidential

Database Administrator

Responsibilities:

• Develop and enforce database standards, guidelines and operational policies and procedures
• Review physical structures
• Review performance, maintenance and utilities
• Review necessary storage media (Disk and Tape)
• Review SQL performance and Tuning
• Reviewing application's access to the database structures
• Review backup & recovery strategies
• Monitoring database/subsystem performance issues
• Design and build web and database servers.
• O/S installation, and installation/configuration of Oracle RDBMS and SQL software.
• Troubleshot, repaired, and patched database and web servers

Confidential

Database Engineer, Administrator

Responsibilities:

• Created Oracle 12c Database using DBCA
• Automated manual function by writing SQL scripts
• Used ER Studio and ERWIN to design database design for new and legacy database
• Migrated legacy database to new database using import and export scripts.

Confidential

Database Professional

Responsibilities:

• Responsible for managing database code, created required branches and ensuring that code is properly checked-in, managed and deployed to pre-prod and production environments
• Worked with release management and application configuration manager to coordinate tasks and activities.
• Perform refreshes of environment to maintain a production baseline in pre-prod environments to support application development and testing
• Ensured that all environments are kept up-to-date with the required version of database code.
• Experience in SQL Server version 2005, 2008 R2, 2012, 2014
• Migrated Oracle and databases using SQL scripts
• Identify bottlenecks In SQL and resolve Issues that prevent data to be updated.
• Familiarity with Powesrhell scripting
• Familiarity with Windows clustering in a multimode environment
• Troubleshoot and resolve trouble tickets using the Remedy application
• Used Linux and Unix to configure database environment and users profiles
• Meet with team and customer to support development and production databases.
• Evening support and weekend support as required

Confidential

Database Administrator

Responsibilities:

• Design and build web and database servers.
• O/S installation, and installation/configuration of Oracle RDBMS and SQL software.
• Troubleshot, repaired, and patched database and web servers.
• Analyzed and determined customers’ data management needs, storage requirements and data
• Designed data structures to accommodate database production, storage, maintenance and accessibility.
• Executed tasks such as backup, recovery, testing and auditing.
• Monitored key metrics in the systems.
• Assisted application developers with database aspects of SQL development (database object creation, SQL tuning, etc)
• Rolled out new application code and upgraded version of SQL Server and Oracle/ builds in various production and non-production Oracle 11g environments.
• Participated in teams that studied data problems
• Work after hours and non peak hours

Confidential

Database Engineer

Responsibilities:

• Create and maintain a development and production database.
• Involvement with architecture, database development, administration, and analysis on an a SQl Server and Oracle 11g database.
• Used SQL to develop stored procedures, triggers and functions.
• Designed, developed, built, analyzed database management systems to include database modeling and design, relational database architecture, metadata and repository creation and configuration management.
• Used data mapping, data mining and data transformational analysis tools such as ERWIN and TOAD to design and develop databases.
• Provided day to day task and direction to junior database engineers in support of organizational projects

Confidential

Database Engineer

Responsibilities:

• Create Promotion Requests to pre and post deploy into a test and production environment.
• Gather requirements, implement, integrate, test, document and deploy.
• Coded using extensive Unix shell scripts.
• Communicating effectively with developers, testers. And system administrators.

Confidential

Database Administrator

Responsibilities:

• Installed and upgraded different version of SQl Server and Oracle databases and application tools.
• Enrolled users and maintained system security using SQL Server Management console and Oracle Enterprise Manager.
• Loaded Data from flat file into ACCESS using SQLoader
• Controlled and monitored user access to the databases
• Performance and tuning of the database by doing trace files, explain plans and creating indexes.
• Backed up and restored the database using RMAN.
• Wrote a cron job on a Linux platform that did incremental backups weekly and daily

Confidential

Database Administrator

Responsibilities:

• Designed, implemented and maintained moderately complex Oracle 9i and 10g databases.
• Maintained data from SQL database and integration of the systems through database design.
• Wrote Unix C shell scripts on a Solaris workstation to perform backups using RMAN.
• Wrote stored procedures and scripts in SQL and PL/SQL to automate the starting up and shutdown of the database using Unix.
• Understand the architecture and structure on how the system for all activities related to the administration of computerized relational database systems operate.
• Monitored and administrated, the performance tuning of database systems in support of the analysis and production operational baseline
• Consulted with users and various members of senior management.

Confidential

Database Engineer

Responsibilities:

• Monitor and administer multiple SQL Server and Oracle database instances to support a large custom software development environment.
• Define and oversee database organizations, standards, controls, procedures, and documentation.
• Provide experienced technical consulting in the definition, design, and creation of a database environment.
• Advise applications development staff and users on database solutions to business problems, data architectures, database management system facilities and capabilities, and the operation and tuning of databases.