System Administrator, Tata Consultancy Service Limited, Brooklyn, MD
Tata Consultancy Service Limited -
Brooklyn, MD,
US
System Administrator
Date Posted: 2024-05-19
Job description
Skill: Database Administrator
#LI-NS2
- Planning, Installation ,Configuration and Upgradeof Oracle 12c to 19c,Sql server 2012 to 2016 and 2019 andPostgreSQL 9.4 / 9.6/ 10/ 11/ 12.
- Sound operating knowledge on Windows/UNIX / Linux platform.
- Hands on experience in RMAN, Exadata, RAC.
- Hands on experience in Dataguard, Managing ASM.
- Hands on experience in performance tuning.
- Managed Production databases in 24/7 environment.
- Having Hands on experience in Backup and recovery strategies.
- Having Hands on experience in Always on high availability, Managing windows failover clustering.
- Knowledge on SSRS and SSIS.
- Knowledge and hands on cloud technologies.
- PostgreSQL tools installation, Configurations PGAdmin III, IV, repmanager, PGPOOL, PGBouncer, pgbadger.
- Advanced Server version 9.X,10.x,11.x,12.x,13.x Installation, Configurations, Backup & Recovery, High Availability, Security and Performance Tuning.
- Co-ordinate and support with other teams for resolves troubleshooting issues.
- sed pg_dump, pg_resotre, pg_basebackup and other PostgreSQL built-in packages.
- Thorough knowledge of database security best practices.
- Experience with Implementation in a Cloud Environment ideal.
- Experienced with PostgreSQL & PostgreSQL Architecture.
- Database user rolesand Security related permission.
- User creation, object Backup & Restore.
- PostgreSQL Index Management.
- PostgreSQL Partitioning and System Catalogs.
- Backup, Recovery and PITR.
- Reliability and WAL.
- Writing shell script for Postgresql.
#LI-NS2