Database Administrator Resume
3.00/5 (Submit Your Rating)
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 AdministratorResponsibilities:
- 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 AdministratorResponsibilities:
- 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 AdministratorResponsibilities:
- 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)