Responsibilities/Activities:– Installation and Maintenance of Oracle 11gR2, 12cR1, 12cR2 on both linux and windows servers.– Implementation of Active Data Guard on Oracle 12cR2 with Data Guard Broker.– Upgradation of Oracle Database version using DBUA utility.– Planning the backups like HOT & COLD backup, Incremental Level 0 and Level 1 backup and Scheduling.– Taking backups using RMAN (HOT & COLD backup) and expdp/impdp (logical backups).– Performance tuning of database by using the AWR, ADDM reports.– Generating SQL scripts as per requirements.– Implementing policies on data confidentiality, integrity, availability and audit ability based on Access Controls for access to data at the database level.– Installing OS both linux and windows on the server machines and making the environment for Oracle Database Server.– Installing Microsoft SQL server 2017 on linux distributions.– Performing day-to-day database administration tasks like tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.

Responsibilities/Activities:– Designing & deploying scalable, highly available, cost effective, fault tolerant systems & infrastructure on AWS using EC2, RDS, IAM, S3, ELB, VPC, EBS, EFS, Elasticache, CloudFormation, Route 53, Auto-Scaling, WAF, Redshift, DMS, CloudWatch & other AWS services.– Configuring, managing & troubleshooting Apache, Nginx, SSL(HTTPS), DNS, DHCP, FTP, Mail, OpenVPN Servers in Linux environment.– Migrating & Provisioning an existing on-premises infrastructure & systems to AWS.– Linux system administration on Ubuntu, Centos, Redhat & Amazon Linux distribution.– 24x7 remote support and on call support.

Responsibilities/Activities:– Installing & maintaining Oracle Database 11g/12c & PostgreSQL Database– Miscellaneous database management and data migration from Oracle database system to PostgreSQL database system.– Constructing various Procedures, Functions using PL/SQL & PL/pgSQL in respectively Oracle Database & PostgreSQL Database.– Taking backups of several MySQL & PostgreSQL database of AWS RDS periodically.– Checking database health status and Restoring database as required.– Working various type of dataset & parsing them using Python & then import them to MySQL.– Migrating an existing on-premises database server like Oracle, MySQL, PostgreSQL to AWS RDS.

Responsibilities/Activities:– Designing & Establishing the internal network using router & switch.– Maintaining, repairing and upgrading network and computer systems.– Monitoring network and systems to improve performance.– Communicating with clients for betterment of projects.