We provide IT Staff Augmentation Services!

Database Architect/dba Resume

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 teh U.S. Visits project and EIS MDI rollout project.
  • Obtain TS/SCI with full scope polygraph

TECHNICAL 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 noledge 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 teh 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 teh 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 teh 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 teh 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 testand production environment.
  • Gather requirements, implement, integrate, test, document and deploy.
  • Coded using extensive Unix shell scripts.
  • Communicating effectively with developers, testers. And system administrators.
  • 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 teh databases
  • Performance and tuning of teh database by doing trace files, explain plans and creating indexes.
  • Backed up and restored teh 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 teh 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 teh starting up and shutdown of teh database using Unix.
  • Understand teh architecture and structure on how teh system for all activities related to teh administration of computerized relational database systems operate.
  • Monitored and administrated, teh performance tuning of database systems in support of teh 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 teh 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 teh operation and tuning of databases.

Confidential

Database Administrator

Responsibilities:

  • Data analysis, design and implementation of Oracle databases.
  • Managed day-to-day developer needs by manage database and instances Using Management console Enterprise manage, SQL Developer and Toad for development.
  • Involved migrating from a 9i database to 10g to 11g.
  • Implementing backup and recovery procedures.
  • Reviewed data loaded into teh databases for accuracy
  • Worked on a full software development lifecycle including application maintenance

Confidential

Database Engineer /DBA

Responsibilities:

  • Participated in customer requirement and database support.
  • Provided design recommendations, and conducted teh database application development using SQL, PL/SQL, Oracle 9i, and Oracle 10g.
  • Used Enterprise Manager to troubleshoot trouble tickets.
  • Added and deleted users accounts, granted privileges of teh database to users.
  • Evaluated designed and implemented existing and new database and application systems to ensure optimal efficiency and performance of deployed systems.
  • Performed analyses, development and evaluation of databases which included database modeling and design.
  • Reviewed data loaded into teh databases for accuracy.
  • Conduct demonstrations, briefings and status reports as required.

Confidential

Systems Database Engineer

Responsibilities:

  • Designed, developed, implemented and maintained a SQL Server and Oracle database.
  • Provided consultation and technical expertise regarding database management systems (DBMS), database management tools, access methods, and vendor-provided database management software.
  • Developed physical database designs, performed database options analysis and made recommendations, and conducted database design reviews.
  • Installed configured, tested, and maintained application databases products and tools. dis included Management console, Oracle Client, Enterprise Manager, and DBCA.
  • Managed database security, including integrity, backup, recovery, access, and changes.
  • Monitored use and optimized database performance.
  • Interfaced with data analysts and modelers, data administrators, application developers, delivery systems administrators, technical support organizations, computing architects, procurement and supplier management, and product vendors.
  • Developed physical data models and consults in development of conceptual data models.
  • Designed, developed, implemented, modified, and maintained physical databases.

Confidential

Database Engineer

Responsibilities:

  • Conceptualized, defined, and developed complex data architecture solutions for large programs..
  • Gatheird requirements, integrate, and implement, test and put into production.
  • Demonstrated experience by developing data design and structuring logical data design, integration strategies, application to database integration, enterprise level data standardization distributed database methods and techniques.
  • Used COTS to support data marts and tera-byte data storage design and implementation.
  • Analyzed relational database design and engineering including traditional Entity-Relationship Modeling.
  • Developed data models and architecture design using ERWIN and Oracle tools. SQL programming and procedural extensions to teh SQL standard (e.g. PL/SQL, stored procedures) was used to analyze database design including data layout and performance tuning.
  • Worked with teh Desktop Support team to troubleshoot customers’ and users’ issues.
  • Assisted teh team lead in comparing files residing on databases, servers, labs and other facilities within teh organization.
  • Supported engineering and analytical activities that required accessing, querying, modifying, testing, and converting law enforcement sensitive data for multiple Oracle databases resident on stand alone workstations and SQL Server database servers.
  • Wrote complex T-SQL code to meet customer’s requirements,.
  • Convert Access code to Oracle to SQL Server for database conversion task
  • Generation of several reports based on user requirements and performance of analysis based on data.
  • Processed fingerprints and facial images using UNIX for teh Lockheed Martin Biometrics and DHS contract.

Hire Now