Oracle &SQL Server DBA Resume Washington - Hire IT People

PROFESSIONAL SUMMARY:

Innovative, perceptible, dedicated, self - motivated and passionate BI developer for over 8 years. Thorough study of oracle Database architecture and ability to work at any stage of the complete structure.
Develop the acuity to learn fast and to face challenges. Grounded with high technical skills at Master level added to two Oracle s: (OCA) and SQL Expert and a Microsoft Certified Professional recognition.
Accepted ingenious and committed team player with excellent, detailed and oriented problem solving skills. Offers universal quality services in English, French, German and many more international languages.

TECHNICAL SKILLS:

Platforms: Windows 8/ 7/2000/2003/ XP/Vista, Ubuntu, Fedora, PLSQL.

Databases: Oracle 12c,11g, 10g, 9i, ADO.NET, Access, Oracle SQL, SQLServer.

Other Software Tools: Visual Studio, Visual Studio .NET., Agile, Power Shell

Networks: Windows NT, Cisco.

Multilingual: Fluent English, French & German

PROFESSIONAL EXPERIENCE:

Confidential, Washington

Oracle &SQL Server DBA

Responsibilities:

As a team player Participated a data-integration project for financial services firm that consolidated information from accounting applications, third-party market data and internal equities/fixed income applications.
Extracted, compiled and tracked data, and analyzed data to generate reports with ssis, ssas, ssrs& Power BI.
Daily performance tuning and troubleshooting assignments, including SQL performance, checking error logs, trace files, system event logs and SQL Server logs for unusual events
Loaded data from flat data files into SQL Server 2016 database tables using bulk insert, and table export/import; loaded data from flat files and excel sheet into Oracle database using SQL*Loader.
Designed SSIS package that extract patient's data from a SQL Server Database by using Lookup task, For each Loop Container.
Used the slowly changing dimension task and its accompanying wizard to load a new dimension.
Designed, performed and tested routine database backups and restore.
Maintained High Availability environment including SQL Server 2016 database Always On, replication and mirroring.
Worked on large database architecture which involved partitioning, materialized views and other data warehousing processes
Established and maintained sound backup and recovery policies and procedures.
Optimized and developed stored procedures, Triggers, Cursors, Joins, Views, Cursors on database.
Created and optimized processes in the Data Warehouse to import, retrieve and analyze data in the Data Mart System (Jobs, DTS, Queries)
Created scripts using T-SQL to automate tasks with scheduler.
Implemented and maintained database security (create and maintain users and roles, assign privileges).

Confidential

SQL DBA Analyst

Responsibilities:

Contributed to auto parts retailer’s 10% revenue escalation in 2013 by standardizing content from different databases, enabling sales and support staff to quickly respond to customer requests.
Installed Oracle software /Created and migrated Database, planed capacity, maintained objects, backed up and recovered database, diagnosed and resolved problems, and managed large databases on a daily basis.
Backed up other dba' s workload as required and Dba on-call support rotations.
Analyzed operational maintenance issues and recommended performance enhancements.
Worked independently and as well worked well with other dba’s on the team and customer on a daily basis.
Monitored and performed tuning on database server.
Involved in database storage and capacity planning.
Worked extensively with BI toolsets including SSIS and SSRS.
Designed, maintain database backups, ETL, and archive using SQL Server backup tools and maintenance plans.
Worked on Sybase ASE for performance tuning and databsse modelling

Confidential

Oracle & SQL server DBA

Responsibilities:

Operated and maintained multiple Oracle database instances.
DBA support of 9i/10g databases.
Developed/implemented plans and schedules for patches, version and release upgrades andmigrations.
Installed, configured and upgraded database Oracle 10g.
Reviewed and implemented database design and implementation (tables, indexes, views, stats).
Performed database tuning and provided recommendations for tuningSetup.
Maintained documentation and standards.
Worked as part of a team and provide 7x24 support when required (rotation).
Performed general technical troubleshootingInterface with Oracle Corporation for technical support.
Performed periodic audits as required by corporate or regulatory bodies.

We provide IT Staff Augmentation Services!

Oracle &sql Server Dba Resume

WashingtoN

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship