It Specialist - Database Administrator Resume
SUMMARY
With 9+ years of work experience in IT area, specifically in Database Administration and Cloud, System Information diploma and currently attending an MBA in Oracle Database Management, I have several courses regarding databases like Db2, SQL Server, Oracle, Netezza and Teradata 14, ITIL framework among others in IT area. I possess too much experience in Database Administration mainly in DB2 considering Linux, UNIX, and Windows environments, becoming a Database Specialist, certified by IBM, always improving my skills.
TECHNICAL SKILLS
Databases: Oracle, DB2, Teradata, RDS MySQL / PostgreSQL
Operating Systems: Linux RedHat, IBM AIX, Windows
Networking: TCP, DNS, IPv4, IPv6
Knowledge in virtual environments: VMware
Cloud Services: AWS services like EC2, EBS, ELB, Auto Scaling, RDS, S3, Route 53
Communication skills: Oral and Written
PROFESSIONAL EXPERIENCE
Confidential
IT Specialist - Database Administrator
Responsibilities:
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 and Teradata load, export/import, monitoring and so on. I also work with Oracle database for transactional environments supporting internal and external clients and supporting a DataStage environment that covers all the ETL for the company. Regarding cloud, Im responsible to support the main AWS cloud services (EC2, S3, RDS, ELB, Auto Scalling, DynamoDB) supporting business units and internal clients in general.
Confidential
Senior Database Administrator
Responsibilities:
Maintain a high critical environment used by IBM 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 Database Administrator
Responsibilities:
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 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
Senior Database Administrator
Responsibilities:
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 IBM (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:
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.
Confidential
Mainframe Analyst
Responsibilities:
Monitoring jobs using tools CA-7, TSO, JCL, JES2, IMS, DB2 and CICS for MVS operating system scheduling in z/VM Mainframe environment and the TWS.