We provide IT Staff Augmentation Services!

Database Architect/dba Resume

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.

Hire Now