Senior Database Administrator Resume
4.00/5 (Submit Your Rating)
SUMMARY:
- With 8+ years of work experience in IT area, specifically in Database Administration, System Information diploma and currently attending an MBA in Oracle Database Management, I have several courses regarding databases like DB2 8.1, 8.2, 9.1, 9.5, 9.7, 10.1, DB2 10.5 BLU, SQL Server 2012 and 2014, Oracle 10g and 11g, Netezza, Teradata 14, ITIL framework among others in IT area.
- I possess too much experience in Database Administration mainly in DB2 considering Linux, UNIX, AIX and windows environments, becoming a Senior Database Administrator, certified by Confidential, always improving my skills.
- I am a self and fast learning, willing to improve my skills in benefit of a company I work for. I believe I am a good fit for your company because I am passionate about IT area, in special databases.
- Please review my resume and consider my request for an interview to discuss how my qualifications and skills would benefit your company. You can reach me at email or phone.
- I look forward to meeting you for an interview where we can discuss more details.
PROFESSIONAL EXPERIENCE:
Confidential
Senior Database Administrator
Responsibilities:
- I´m the senior DB2 LUW DBA in a Confidential environment.
- I support the DB2 appliance regarding databases running in DB2 10.1 DPF and AIX SO, since the development, uat and production databases for a datawarehouse environment, which has about 40 TB in size in a 24x7 production environment.
- I´m responsible for data modeling approval, database object creation, tablespaces maintenance, storage definition, database design, instance management, migration and fixpack updates, sql tuning, development of scripts, database performance, use of db2 utilities like db2load, export/import, db2advis, db2pd, db2top and so on.
- I also work with other databases in this project and they are Oracle 10g / 11i and Teradata 14 and DW BI tools like DataStage 8.7 / 11.3 (Design, Director, Administrator), Hyperion and Cognos.
Confidential
Senior DB2 LUW DBA
Responsibilities:
- I'm the senior DBA for Confidential client supporting all databases regarding internal applications to control on and off board contractors.
- I'm responsible to maintain a high critical environment used by Confidential worldwide based on DB2 9.7 and DB2 10.1 on zLinux operating system.
- I support all data model changes, object creation, development in shell script to automate database tasks for deploys, backup, restore, performance and tuning for the database environment, HADR setup, version upgrade, apply fixpacks, monitoring, load of data using db2 load, import, export, problem determination using db2pd, common tasks like reorg, runstats, redirect restore, storage groups, db2 compression for storage save and so on.
Confidential
Senior DB2 LUW DBA and Confidential NETEZZA DBA
Responsibilities:
- I’m the DB2 LUW DBA for production, test and development environments and also Confidential Netezza Data Warehouse DBA and System Administrator.
- Main responsibilities in DB2 environments are creation of database objects according to application requests, use db2look to collect database architecture, load/import of data, configure and maintain HADR for production environments, use of administrative views for monitoring, runstats, backup and restore, STMM, db2pd, db2top, database performance and tuning, physical / logical / conceptual model, security management about authorities and privileges (users and groups) in a 3TB+ DB2 Database and so on, using Business Glossary as data dictionary tool. Regarding Netezza environment
- I’m responsible to create and maintain users and groups, create databases, load of data using nzload, backups using nzbackup, execute queries for analytical data, generate statistics, groom tables, administering SPA, S - Blades and so on.
- Also working as DBA with Oracle 10g / 11i and SQL Server 2012 for marketing and credit applications.
- I was also responsible for the DataStage administration, supporting the ETL development team.
Confidential
Sênior DB2 LUW DBA
Responsibilities:
- Working as DB2 LUW DBA on AIX environment for Bradesco Cards supporting all DB2 databases for developing, test and critical 24x7 production environment of a financial application.
- Main tasks were Backup / Restore strategies, roll forward, Installation, Upgrade, Performance, Tuning, configurations of logs for a better recovery environment, STMM, use of DB2 features (db2move, db2look, Import, Export, db2eventmonitor, db2pd, db2top), HADR, database physical / logical / conceptual design and so on.
- I also performed DBA roles in other environments for the same project working with Teradata for DataWarehouse, Oracle 11g for transaction application and SQL Server 2012 for transaction application as well.
Confidential
DB2 LUW DBA
Responsibilities:
- Responsible for all tasks and administration of DB2 LUW databases in production environment for all internal applications from Confidential (HR, financial, sales) on distributed environments (Linux, UNIX, Windows, AIX)
- Backup, Restore, Reorg, Runstats, DML/DDL/DCL, Tablespaces (DMS/SMS/Automatic Storage), Installation and Upgrade fixpack, DPROP (Data Propagator), DB e DBM CFG, db2 tools like db2pd, db2top, among other tasks.
Confidential
Mainframe Analyst / Shift Leader Backup
Responsibilities:
- I was production support for Mainframe and Distributed environments for Confidential client.
- Scheduling of jobs, editing JCL, JES3, TSO, IMS, CICS, DB2 on MVS and z / VM and Autosys (Windows and UNIX) in a distributed environment.
- Also serving on the coordinating team and administrative procedures as Shift Leader Backup.
