• Collect the data provided by the field operators for backups.
• Upload the daily report of the collected data on the central server.
• Resolve the Hardware/Software related issue of the tablets.
• Install and Educate the operators about the Tablets and its working.
• Visit different tracking Centres for the progress of the work and share the reports with the authorized govt. officers. 

• Sql
• make the sql request 
• Responsible for database security and also preventing data loss.
• Identifying and escalating immediately any risks to the database service.

• Installing and maintaining databases.
• Administration of the database including performance monitoring and tuning.
• Taking part in the preparation and execution of technical tests.
• Populating a database with new information or transfer existing data into it.
• Creating backup copies of data.
• Daily maintenance of firewall protection and file security.
• Development of web based interfaces for Oracle databases and web applications.

•  Work with popular database systems like MySQL and PostgreSQL 
•  Manage a SQL database  
• DDL – ability to define different database objects.
• DML – ability to manipulate the data stored in the objects.
• DCL – ability to control access to the data and objects.
• Dynamic SQL – ability to frame SQLs with some unknown factors.
• SQL performance tuning – Ability to understand execution paths and optimizing them. 

• Oracle Database Administrator supporting different flavors of Oracle database as the primary module. 
• Database Administrator for SQL Database as the secondary module.
• DBA for Production, Test & Development Instances of Oracle 11i, R12, Applications and databases. 
• Installing, Patching, Cloning of Oracle DB and Applications 
• Backup and Recovery strategies using RMAN, Hot Backup, Cold Backup, import and export utilities. 

• Outages: Leading Outage Activities (Application patching and DB patching, Production/non-prod change requests) 
• Alerts and Performance Monitoring using check_mk, Splunk , OEM Tools
• Provide SQL DBA , MS Dynamics Navision technical support to junior staff or clients.
• Set up database clusters, backup, or recovery processes as per project standards.
•   Fixing Replication Issues and Cluster Issues
•  Backup Maintenance Planning
• writing Powershell scrips to send Service availability Reports

• Installed, Supported and customized licensed DB2 software related tools
• Provided timely resolution to DB2 software related problems including 24/7 on call support
• Upgraded DB2 subsystem to newly released versions
• Worked with Technical support team to identify DB2 related problems 

• Database administration for 180+ customers and 1500+ Tracking units
• Emergency Control Room Operations. – Alarms, Theft, Hijackings and Recoveries 
• Existing and New customers database logging on Mtrack systems
• Unit status checks and remedial actions execution
• Co-ordinating service and installation of tracking devices with clients
• Coordinating technicians in the field
• Assisting technicians onsite with new installations and battery changes

• Tuning and operability guarantee of databases; 
• Backup and recovery; 
• Patch’s install; 
• Customer’s Database Migration (Oracle 10 to Oracle 11g); 
• Monitoring implementations using Zabbix, shell scripts, crontab, bat scripts, VB scripts, task scheduler, PLSQL and T-SQL. 

• Create, maintain, and enter information into databases.Plan and install upgrades of database management system software to enhance database performance.
• Oracle Database Administration
• MicroStrategy Testing 
• SQL Server Administration

• Automate the excel to develop system performance reports.
• Deploy changes in Production.
• Providing support to client on various Teradata Utilities.
• Plan and support upgrades of database management system software to enhance database performance.
• Create and enforce database deployment standards.
• Develop or maintain procedures for space movement, profile change during deployments etc.
• Monitor and Schedule the backup jobs

• Created, reviewed and implemented maintenance plans on production servers.
• Created and maintained documentation for DBA standard operating procedures.
• Supported clustered and non-clustered environments as well as log shipping for disaster recovery.
• Monitored and solved performance issues.

• Collaborated with staff, users, and management to establish requirements for new systems or modifications.
• Collaborated with the InfoSec team to develop security policies. 
• Performing backup and recovery 
• Implement security and encryption

• Build database schema, tables, procedures and permissions
• Working closely with IT project managers, software developers, database programmers and web developers
• Building PL/SQL program and SQL queries for programmers
• Establishing the needs of users and monitoring users access and security
• Monitoring performance and managing parameters to provide fast query responses to front-end users
• Exporting and importing of data in different formats e.g. csv, text, xml 
• Performing database migration and replication

•  Test programs or databases, correct errors and make necessary modications. 
• Work as part of a project team to coordinate database development and determine project scope and limitations. 
• Specify users and user access levels for each segment of database. 
• Approve, schedule, plan, and supervise the installation and testing of new products and improvements to computer systems such as the installation of new databases. 
• Review procedures in database management system manuals for making changes to database. 
• Develop data model describing data elements and how they are used, following procedures and using pen, template or computer software. 
• Select and enter codes to monitor database performance and to create production database. 

•  Automated messaging services on server failures, for task completion and success. 
• Trained new joinees on Database technology.
• Planned and implemented security measures to safeguard data.
• Tested programs and databases and made necessary modifications.

• Analyze long running slow queries and system performance. 
•  Implementing Mirroring and Log Shipping on database servers. 
• Monitoring Transactional replication. 
• Used Activity monitor to find the bottlenecks in CPU, Disk I/O and memory devices. 

• React to unexpected DB problems. 
•  Managing privileges & roles to ensure the application/database security. 
•  Creating the users as & when new resources are allocated to a project 
• Export/Import Database / Schema / Tables. 

• Wrote and coded logical and physical database descriptions.
• Coordinated with project teams on database development timelines.
• Wrote and maintained technical and functional specifications.
• Specified users and user access levels for each database segment.
• Modified existing databases to meet unique needs.
• Implemented database designs and data models.
• Determined business and functional requirements for business needs.

•  Collaborated with company staff to optimize working environment and customer service.
• Ran routine phone troubleshooting and configuration.
•  Managed and Configured deployment environments of a web application.Troubleshooting crystal report server, oracle database and Weblogic app server.
• Routine DBA activities like Regular backup, retrieval of the database from backup, creating users, etc 

• Handling complete Database administration.
• Coordinate new deployment requests.
• Managing DEV, QA & PROD cycle.
• Lead company newsletter.
• Coordinate team building activities
• Lead or contribute to new product development.
• Coordinate CSR activities in company.

• Database installation. 
• Understands the current database environment and future database needs.
• Job Monitoring and debugging failed jobs. 
• Monitoring of database size and disk space in Production, Staging & Development environments. 
• Used SQL Server Profiler to monitor and record database activities. 
• Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform 
• Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data. 

• Update knowledge and skills to keep up with rapid advancements in information technology.
• Test and verify software to ensure that they meet specifications and requirements, by recording and analyzing test data.
• Write detailed functional specifications that document the software development process and support software introduction.
• Make easy feel and friendly environment to cope with users and developers for their requirements satisfaction.

• Handling and solving Database transaction issues.
• Sybase application troubleshooting
• Sybase nod syncing activity.
• Application trade re-fetch.

• Operate telephone switchboard to answer, screen, or forward calls, providing information, and taking messages
• Balancing the load on the system using the Workload Management.
• Achieved QoS 15% more of what is expected. A perfect 2/2.
• Patching Oracle Database 

• Administering all Airtel Oracle databases 
• Installation, configuration, and upgrading of Oracle server software and related products 
• Take care of the Database design and implementation 
• Implement and maintain database security (create and maintain users and roles, assign privileges) 
• Perform database tuning and performance monitoring 
• Performing database backups 
• Monitor database events, troubleshoot faults and resolve problems 

• Demonstrate database technical functionality, such as performance, security, and reliability.
• Create and enforce database development standards. the generic database structure.
• Automate the user management process using the Excel.
• Schedule stats collection in Stats Manager Portlet.

• Maintains different Database Environment for different clients successfully by performing all DB related activities.
•  Keeping the Databases performance in check.
•  Kept the Data Safe and Secure and maintained Data integrity.
• ZERO Deviations on Technical/SLA processes.
• Achieved the MTTResponse by 99% more of what is expected.
• Achieved the MTTResolve by 78% more of what is expected.
• ZERO SLA misses.

• Monitor and report systems resource consumption trends using the PDCR tool to assure production systems meet availability requirements 
• Oversee the performance by tuning the long running or poor performing queries.
• Deploy changes in production database.
• Implement the procedure for space and user management.
• Plan and Schedule the backup jobs.
• Monitor and schedule the DataMover jobs.
• Develop and Setup various Alerts in Teradata Viewpoint.