We provide IT Staff Augmentation Services!

Database Administrator Resume

SUMMARY:

  • Over 8+ years of Dynamic IT career reflecting pioneering experience and high performance in Database Administration and maintenance using Confidential Netezza 6.x/7.x, Hadoop, AWS Redshift and Tableau.
  • Experience in regular Database Administration activities such as Upgrades, Migration, Patches, Cloning, Backups and Recovery Manager, script development, and documentation.
  • Exposure in Data Warehouse systems Netezza (NPS), Big Data, AWS Redshift and BI Tools like Tableau and Microstrategy.
  • Efficient in configuring and monitoring Backups in AWS Redshift,Netezza, Hadoop and Tableau.
  • Excellent interpersonal and strong analytical, problem - solving skills with customer service oriented attitude.
  • Good co-ordination and communication with System Administrators, Business Data Analysts and Development teams.
  • Good experience in sys admin activities like creating, activating & managing user accounts & responsibilities and profiles.
  • Expertise in space management & database storage management.
  • Ability to work as an individual towards the team goal.
  • Flexible to move anywhere based on the requirements.
  • Good Team player, highly motivated, hard working towards the commitment.
  • Willingness to work in a highly dynamic environment and ready to take up challenges.
  • Creative, self-motivated and committed to excellence under minimal supervision.

PROFESSIONAL EXPERIENCE:

Confidential

Database Administrator

Responsibilities:

  • Have 6+ months of experience on AWS Redshift
  • Worked as part of the AWS Built team, planned, deployed, monitored, and maintained Amazon AWS Cloud infrastructure consisting of multiple EC2 nodes.
  • Responsible for S3 bucket creation, writing policies and IAM role based policies
  • Created bucket policies to encrypt data stored in S3 buckets and generated life-cycle policies to manage cost-effective storage.
  • Created and configured elastic load balancers and auto scaling groups to distribute traffic and to have a cost efficient, fault tolerant and highly available environment.
  • Involved in creating IAM Users, Groups, Roles, Identify Providers and defining Policies and applying to IAM Users and Groups.
  • Taking Manual snapshots and restore from snapshots
  • Restores using Unload and copy commands from S3 Buckets
  • Used Lambda Functions Along with API gateway to effectively maintain server less Architecture.
  • Used security groups, network ACL's, internet gateways
  • Designed AWS Cloud Formation templates to create custom sized VPC's, Subnets, to ensure successful Cloud deployments and database templates.
  • Have 8+ years’ experience on Netezza
  • Supporting the NPS twinfin and striper servers for end to end solutions
  • Have used nzbackup and nzrestore to backup and restored the big databases from one server to another server during the migration.
  • Extensively used nzsession, nzsystem, nz skew, nzstats and nz health utilities to monitoring the skew and distribution of all tables, NPS server issue for better performance
  • Established security LDAP authentication, users and groups
  • Used nz migrate, nzload to load and unload the data from text files and other databases
  • Have renamed the old Netezza sever with new name
  • Used nzstop, nzstart to restart the NPS and have done manual vacuum using nz manual vacuum
  • Have configured history database to collect all column and table level history info.
  • Created databases and designed the database objects with appropriate parameters
  • Upgraded NPS 7.1.0.4 to 7.2.1.4
  • Co-ordinated with NZ support to resolve many other issues, disk replacements and hardware components replacement.
  • Wrote shell scripts to automate ETL jobs, nz process related jobs, groom, genstats etc
  • Have monitored the performance issues, database usage, hardware components SPUs, SPA, Disks and raise PMRs with Confidential NZ support to resolve the issues and upgrades.
  • Installed setup of SQL extensions and INZA on the Netezza performance server
  • Have 2+ years’ experience on Tableau
  • Familiar with Installation, configuration, patching and upgrading of Tableau tool across the environments
  • Manage the application’s users, groups, and integration with Active Directory
  • Automate monitoring & server job processes
  • Should be capable of doing Tableau Server Management (like Clustering, Load Balancing, User Management etc)
  • Knowledge of Tableau Licensing
  • Should be familiar with tableau migration and scheduling.
  • Experience in taking back ups and restoration of Tableau repository
  • Good knowledge on Tableau Metadata tables and Postgre SQL
  • Have 2+ years’ experience on Hadoop
  • Responsible for implementation and support of the Enterprise Hadoop environment.
  • Involves in designing, capacity arrangement, cluster set up, performance fine-tuning, monitoring, structure planning, scaling and administration.
  • Work closely with infrastructure, network, database, business intelligence and application teams to ensure business applications are highly available and performing within agreed on service levels.
  • Implement concepts of Hadoop eco system such as YARN, MapReduce, HDFS, HBase, Zookeeper, Pig and Hive.
  • In charge of installing, administering, and supporting Windows and Linux operating systems in an enterprise environment.
  • Accountable for storage, performance tuning and volume management of Hadoop clusters and MapReduce routines.
  • In command of setup, configuration and security for Hadoop clusters using Kerberos.
  • Monitor Hadoop cluster connectivity and performance.
  • Manage and analyze Hadoop log files.
  • File system management and monitoring.
  • Develop and document best practices
  • HDFS support and maintenance.
  • Setting up new Hadoop users.
  • Responsible for the new and existing administration of Hadoop infrastructure.
  • Include responsibilities like data modeling, design and implementation, software installation and configuration, database backup and recovery, database connectivity and security.

Confidential

Database Administrator

Responsibilities:

  • Confidential Netezza (NPS) Administration.
  • Good Understanding of the Netezza Architecture and underlying data distribution
  • To ensure the Gen Stats updated on all respective tables in Netezza.
  • Handle Materialize views, zone maps for performance tuning.
  • Performance Tuning in Netezza and writing ADOC Queries (NPS Netezza Performance Server)
  • Good experience on NZSQL, NZ MIGRATE, NZLOAD, NZBACKUP, NZRESTORE, NZPLSQL
  • Creating and Maintain the Database on NPS.
  • Creating and Monitoring Netezza event manager alerts
  • Managing all kind of NZSQL utilities process.
  • Creating user, groups and grant the respective permissions
  • To migrate data from various NPS to another NPS system
  • Data Migration and Up gradation of Netezza system.
  • Writing Shell scripts.
  • Query History maintenance.
  • Experience with PMR - raising and providing support.
  • Handling the SAN storage activity.
  • Scheduling Incremental & Full Backups

Confidential

Database Administrator

Responsibilities:

  • Upgraded oracle database from 10g to 11g.
  • Creating, configuring and maintaining oracle 11g database based on specifications using dbca and manual methods.
  • Applying patches for Oracle databases.
  • Maintaining Control file, Redo log file, Data file.
  • Database refreshes using exp/imp and expdp/impdp.
  • RMAN Managed and User Managed Backup and Recovery operations.
  • Oracle Database refresh / Migration from Production to Development.
  • Data Guard - Maintenance of Standby database.
  • Proactive monitoring for production databases.
  • Hands on experience on Linux installation and RPM's installation.
  • Database administration tasks included performing regular Hot & Cold Backups, Job Scheduling.
  • Data transferring with Export/Import, Data Pump, Transportable table spaces.
  • Oracle Enterprise Manager (OEM) database control.
  • Performed operations like creations of users, session management, and grating privileges to users for database security.
  • Creating Materialized-views and Database Links.
  • Handling Incident, Work Request and RFC via ticketing system.
  • Oracle Data Integrator (ODI) Administration.
  • FMW ODI11g Upgrade.
  • Installation, configuration and maintenance Oracle Data Integrator (ODI), MSTR on Windows system.
  • BI Tool Microstrategy Administration.
  • Confidential Netezza (NPS) Administration.
  • WebLogic Server setup and Administration.
  • ODI and MSTR Code Deployments.
  • Responsible for User Accepting testing (UAT)

Hire Now