Senior SQL Server Database Administrator
VIC - Melbourne Metro
Specialties
Administrator
Database Administrator
SQL

Strong with Attitude of Never give-up and Can-do trustworthy.

Summary

More

Career

DENTAL HEALTH SERVICES OF VICTORIA - Senior SQL Server Database Administrator
IT Services, Software & Hardware - Government and Defence
Australia
Specialties
Administrator
Database Administrator
SQL
Responsibilities
  • Log Shipping Between Server Instances - Configuring, Installing, Scheduling, Disaster Recovery Victorian State for regularisation and Data Capacity plans
  • Along with project manager to determine databases for Consolidation on a new third-party software package for 64 Dental Agencies
  • Support Payroll Department Microsoft based ERP package for generating Employee Information System Design and Generation of Modules
  • Strategic maintenance alignment business and IT Production, Development, Agency Servers / DB's for application-orientation
  • Establish production 2-Node Clustered Servers- databases Network Infrastructure Connections System 500-MegaLink
  • Responsible for Active Directory Server for End-user Logins & Accounts; IT Service Continuity Management, Disaster Recovery Plans & Fail-Over-Clusters
  • Cross-check the SMS Reminders application on daily basis for all Victorian for SDS and CDP Patients
  • Managed, Monitored health of Servers / Instance-wise including backups & restores (Veritas / CommVault / VEEAM) across SAN Storage Fusion Networks
  • Data uploads from ISAM to SQL for upgrade of all Agency databases Consolidation- Data Ware House Refresh
  • End-User Performance; Troubleshoot; Improvement; Connectivity; Accessibility; & Report Generation including Documentation
  • Development & Testing Arena in SQL Server 2012 SP1 Version *** Development / Testing Servers for Dental Packages before implementation
  • 99% Maintenance successfully with Organised Plan for Log Shipping /Clustered / Application / Development / Testing Servers
  • Organised Scripts for Jobs automated for smooth transition of Data Encapsulation / Manipulation with Agencies
  • Zero Percent downtime for Agencies Data Accessibility & Storage with fail-over capability
  • 100% Achievement of Maintenance Plans Scripts driven for agency data ;
More
VICTORIAN LEGAL AID - Senior SQL Server Database Administrator
Australia
Specialties
Administrator
Database Administrator
SQL
Responsibilities
  • Design, implementation Clustering databases with Wide System Level Skills in Team Environment organization policies in codification, documentation
  • Edification of Database Management (DBMS) for the organization policies in codification, documentation with ITIL standards (Service Support & Delivery)
  • Initial build script development and maintenance; Implementation into production database; Creation and Schema maintenance
  • Data migration SQL Server 2k to 2k5, Reverse / Forward engineering of all DB objects; Schema comparisons - TOAD; with MS-VISIO 2000 ;
  • Optimization processes by parallel processing; Troubleshooting and 2nd-level support for application issues,
  • Application vendor system Performance checking to 100th milli-second; error notification; statement analysis & tuning
  • Role performance during peak transactions; Conversion of text file (initial load) data & Manage Helpdesk, Citrix environment
  • Backup & Recovery; troubleshooting; Storage analysis and allocation: Disaster Recovery Plan (DRP) Strategies and Changeover Instances among servers
  • Database Email Notification alerts: Helpdesk & Developers based on Intel Based Citrix systems across Internal Departments
  • Implemented complicated distributed 24/7 transaction & reporting system spread over multiple data centres & versions; Hard Cat 3.27v & Aurion 9.3.01v
  • Regular Monitoring the plans for DRP techniques and prepared the code for eventual recovery procedures
  • Developed product database, implementation of development cycle to developer support, testing, remote conversion & verification ;
More
GAP BUSTER WORLDWIDE - SQL Server Database Administrator
Australia
Specialties
Administrator
Database Administrator
SQL
Responsibilities
  • Helped build, support a local software team to reduce cost, time to market; significantly increase quality of releases through DWH Design for OLAP
  • Frequency plan & structure codification for Clustered Environment Databases - Disaster Recovery Plan (DRP) and implementation, Software release patches
  • Implementation of iMIS Subjective across the Global markets of the Shoppers system shipping maintenance release
  • Practical implementation of the Zonal Codes for the various Shoppers data reflected in respective servers
  • Standardized database software releases and install procedures and wrote automation to install releases off-hours.
  • Supported development, project management and business analyst teams in addition to supporting high-volume call centre, production database, archives database (data warehouse), training and multiple test environments.
  • Remote control of Intel based systems for Synchronization process for better Replication across global network, Data Refreshes for logical Structures
  • Subject matter expert for SQL, database installs, database logical and physical structure, storage allocation
  • Application development support to Analysts on all aspects of programming, archive database through REVERSE Engineering for SRS and Design Series
  • Troubleshoot application & performance issues, with process simulation to identify issues; implement refined solutions short and long-term issues solutions
  • Gathering stale statistics (performance tuning) statistics for tables, DB metrics relevant to performance monitoring and tuning
  • Improved success rate of deployed tasks per test failure by more than 150% as part of development team
  • Improved overall productivity of the development lifecycle by over 40% as part of development team
  • Drastic reduction downtime and improved performance; Rebuilt, reorganized, enhancing development; maintenance and performance & Improved database replication practices on-demand, one-hour refresh (Transactional Replication)
  • Automated backups, software release installs, performance tuning and database metrics gathering
  • Improved backup processes resulting in one-minute (downtime) cold backups
  • Documented most critical procedures and trained backup staff to run them. ;
More
SYNERGY PLUS - UNIX / Oracle Database Administrator
Australia
Specialties
Administrator
Oracle
Database Administrator
Responsibilities
  • Determining the RAC Architecture tasked with Partitions of I-Mode Clustering Production Database regularizations; Backup & Recovery Procedures;
  • create fresh test environments Developed software to monitor: Partitions; Veritas Clustering Software 9.2, Net Apps Filers
  • Responsible for all software release installs to test/ training / production maintenance, improve archiving production
  • Liable to data refreshes, development / training, storage allocations, includes rearrangement on Logical structures
  • Application Tuning Buffer Partitioned Table spaces; Access & Availability, End-User Performance tracing; SQL queries, Application Daily transactions
  • Administered Oracle 9.2 on Sun Solaris 2.8 and Linux 8.2 platforms at Telstra based Production Environments.
  • Designed and implemented new custom database for DRP Solutions for Fail-over Instances at Disaster Recover y within mean time
  • Maintain Archives across the VCS to failover instances round the clock; Data Availability during changeover instances ;
More
FAMILY MIGRATION FROM INDIA TO - -
Australia
STATE GOVERNMENT - -
Australia
Responsibilities
  • Configuring Managed Databases (CMDB) across the Finance, Welfare Departments with Archives REINS; SBMS & GIS Applications on AIX OS.
  • Configuring, Maintaining Data replicated Archives to NIC Server: Data Guard, Database Design 9.0.2 to 10.1.0.2 Sun Solaris & Linux V 7.x, 8.x
  • Initial to Secondary tasks included participation in test lab procedures: OS installs, network and application troubleshooting.
  • Data Security / Integrity, Forward / Reverse Engineering - Data model; Disaster Recovery; Backup & Recovery Using RMAN
  • Data Load through SQL * Loader, on Collection & Abstraction of data - Data Analysis; Performance tuning for SQL Buffer Cache
  • Auditing Department users, Roles, Privileges; Tuning End-User Components for Application & Memory - Performance
  • High-level design documentation & system test specifications - Architecture & Design; Data Analysis for ITDA GIS module
  • Maintenance of RAC based Instances on NIC Server Fail-over-Instances for Sister-concerned department level - 3rd level
  • DBMS_SCHEDULER to maintain the Migrated database queries for stored outlines
  • Created a robust successful client-server system program from scratch variety of client components to test a server running on AIX; Solaris & Linux. ;
More
DEVELOPMENTS & INVESTMENTS HOLDINGS PTY LTD - SQL SERVER DEVELOPER
Australia
Specialties
SQL
Responsibilities
  • Design, implement, & design automated Backup / Restore, maintenance & integrity processes Forward Design
  • Preparation of SRS (Systems Requirements Specification) - IEEE Standards
  • Performance Tuning, Installation & upgrade version 7 to 2000 on Windows 2000 server
  • Accomplished the Task of foolproof creation of New Server's Physical Database for Construction Site ;
More
BHARAT DYNAMICS LTD - -
Australia
Responsibilities
  • Supporting Missile Program Aviation technology using TRAX Database Management
  • Oracle based which allows for interfaces and 3rd party tool integration for maintenance TRAX Management
  • JBoard to multiple SQL-injection Mapping for Application Performance
  • Allocation & creation of table spaces, user roles, time constraints, auditing - Database Administration
  • Regular backups (cold & hot), Reorganization of database from 7.3 to 8.0.5
  • Logical backups (incremental & complete); Memory & Application tuning TKPROF & EXPLAIN PLAN utilities ;
More

Education and Qualifications

Year Qualifications Level Institution
2008 Microsoft Certification Other Unknown No
1991 PGDCA Other Osmania University No
1989 Bachelor of Science Other Osmania University No