Oracle / SQL DBA / Consultant

Altro Limited

* Provide Oracle and SQL Server database support to a mixture of critical, test and development
databases. Support includes routine DBA tasks such as backup and recovery of full and partial
databases using RMAN/HPDataProtector, performance tuning of SQL and PL/SQL code, system and
databases
* Provide detailed architecture, consulting, engineering, implementation and support for database
availability, backup and recovery, and performance tuning projects.
* Provide system DBA engineering, implementation and support for Oracle JD Edwards Applications
using Oracle databases.
* Add clients to HP Data Protector and schedule both Oracle and OS filesystem backs using HP Data
Protector
* Designed and implemented Oracle database High Availability solution using RAC, GRID, and ASM
* Designed and implemented Disaster Recovery solution Oracle standby database using Dbvisit
* Provided primary SQL Server support and monitored performance for all databases instances and the
Business Objects/Crystal Reports server.
* Rewrote queries, stored procedures, and created missing indexes used in the company's ASP-based
reporting portal application and developed a new set of Crystal Reports used by external clients.
* Monitored and fixed nightly maintenance; optimized and improved DTS and SSIS packages.
* Designed, installed, and configured of VMWare vSphere ESXi 5.1 including network, storage, High
Availability, and Fault Tolerance
* Supported and maintained VMWare infrastructure for Altro - 5 ESXi hosts with 140 VMs, and one
vCentre Server
* Designed, installed, and configured VMWare vCentre Server for managing VMware vSphere ESXi hosts
* Planned and upgraded vSphere 5.1 to vSphere 6
* Supported and maintained Oracle Linux Servers running Oracle WebLogic and Oracle Enterprise
Database in development, testing, and production environments
* Supported and maintained Oracle Linux Cluster infrastructure using HP storage technologies
particularly EVA P6500
* System administer for several critical LOB applications - JD Edwards ERP applications, Pivotal
CRM, and SharePoint

* Responsible for managing the MOD's ten terabyte data warehouse using SQL Server and providing
* training for ETL using SSIS and Talend.
* Project Manager for all SQL Server data used during the Olympics by the police and military.
* Ran the MOD's secure version of Google Earth using SQL Server and ESRI products
* Supported and maintained Oracle 9i/10g/11g / MS SQL 2005/2008/2012 databases on Windows 2008 and
2012 server platforms in development, testing and production environments.
* Supported and maintained Oracle 9i/10g/11g on Redhat Linux and Oracle Linux in development,
testing and production environments
* Performed all day-to-day (Business As Usual) aspects of Oracle / MS SQL SERVER database
administration.
* Performed level 2&3 support, maily project related work. Responsibilities include database
design, installation, configuration, upgrades, security, performance monitoring and tuning,
database availability, backup and recovery, troubleshooting and problem resolution.
* Developed scripts, automating complex or repetitive dba tasks.
* Ensured databases adhere to corporate standards and policies, including database auditing.
* Served as liaison to other business units and organizations for process improvement, compliance
and standardization
* Providing support to, and developing, the regional Oracle/SQL databases and developing,
implementing and supporting a variety of regional and national Geospatial Web Mapping
Applications for Geospatial Intelligence dissemination and other SharePoint based systems.
* Use system administration tools to investigate diagnose and resolve complex and/or high risk
problems to maintain service level agreement levels, as well as analysing consistent problems and
providing long term pro-active fixes.
* Provide 2nd/3rd level support to the IT Support Engineers and Project Teams as required.
* Carry out complex configuration/installation and reconfiguration of hardware and software for
business as usual changes or projects as required. Additionally, carry out research and
development of technical products in accordance to business as usual or project requirements.
* Provide technical options papers with risk analysis, costs and implementation plans. Recommend
and implement standards for configurations, tools and products.
* Define and maintain system documentation, i.e., standards, security orders, procedures,
configuration information, help desk calls, etc., and ensure that less experienced staff are
instructed in their use.
* Use management software and appropriate analysis equipment to collect system statistics, model
performance, and create reports including proposals for improvement. Where necessary also use
this information along with details of current and expected technology change, system growth and
business needs to provide complex capacity planning models for future planning and budgeting.
* Manage internal staff and external consultants, suppliers and vendors both on day to day support
and in designing and implementing system installations and changes.

* Management and delivery of instruction in Information Systems in all Information Systems and
Geographic IS related courses.
* Manage the overall design, development and production of detailed course training plans for
training programmes or courses that are fit for purpose for meeting the training objectives of
information systems specialists and geospatial intelligence officers.
* Provide subject matter expert advice to stakeholders and training partners on technical course
design and course development matters associated with information systems geo intelligence
capabilities.
* Ensuring the delivery of quality training in the theoretical and practical aspects of Information
Systems.
* Lead for technical expertise of the staff and representative of DCI / Defence as a subject matter
expert (SME) in the field of Information Systems.
* Periodically reviewing, revising, and where necessary developing new academic programmes and
related documentation to meet geospatial intelligence capability needs.
* Module Manager for two FdSc modules (5281 - Database Design and Implementation, 5282 -
Information Systems Management, and an MSc module (GISM - Geospatial Information Systems
Management).
* Supervises undergraduate and master students.
* Member of the following school boards and committee: Quality Board, MSc Course Committee,
Foundation Degree Course Committee, Training Development Committee.
* Teaches and assesses GIS management other information systems courses at Cranfield Defence
Academy, Cranfield University, and Sheffield Hallam University
* Supervises masters and doctoral students at Cranfield Defence Academy and Sheffield Hallam
University.
*

* Planning, Deploying and rebuilding Microsoft and Linux servers and configure hardware,
peripherals, services, settings, directories, storage, etc.
* Planning, Deploying and rebuilding Servers applications like Microsoft AD Directory Services,
DHCP, DNS, File services, IIS, Apache, Print and Document Services, SharePoint, WSUS, SQL
Server, Hyper V, SNMP, SMTP, SSL, Failover Clustering and Remote Desktop services.
* Installing, administering and maintaining Checkpoint firewall, Cisco Routers, IP PBX, Switches,
Access Points, Security Cameras, Biometric systems and other active network devices.
* Implementing and administering network access policies through LAN, WAN, VPN terminals, and other
Remote Access Protocols with the aim of ensuring availability and secure connections.
* Researching and recommending innovative and where possible, automated approaches for system
administration tasks. Identify approaches that leverage our resources and provide economies of
scale.
* Carry out scheduled and continuous system monitoring to ensure integrity and availability of all
network hardware, resources, systems and processes.
* Reviewing system and application logs, and verifying completion of scheduled jobs such as
backups, WSUS Updates, Firmware upgrades etc.
* Create, update, and delete systems user accounts as per requests.
* Monitor and perform periodic network performance reports to support capacity planning.
* Evaluate and recommend LAN/WAN hardware, Software and peripheral equipment during procurement.
* Liaising with internet service providers with the intention of ensuring continuous and reliable
internet connections
* Designing and updating network infrastructure documentation - security, configurations, tests,
patches, etc.
* Capacity building of IT Support officers, to better tackle routine calls.
* Performing other duties as assigned by the supervisor.

* Development, preparation and delivery of teaching, learning and assessment both at undergraduate
and postgraduate levels
* Evaluation, development, organisation and management of the curriculum in terms of content,
delivery, and assessment
* Contributing to the wider student experience e.g. through personal tutoring, participation in
recruitment, involvement in career advise
* Promote the use of a range of methods and techniques in teaching, learning and assessment
* Supervise masters' students dissertations.
* Pursuing a personal research programme consistent with the research priorities of Middlesex
University school of Engineering and Information Science leading to award of doctor of
philosophy.
* Publishing the outcomes of research in outlets of international standing.

* Responsible for designing, implementing, debugging and documenting the following Java technology
systems: networked reservations, trip scheduling, billing and reporting; real-time call entry
and vehicle dispatching; interfaces to electronic billing, automated eligibility verification,
remote accountability and quality assurance services
* Analyze requests for custom software development and data requests and provide estimates of time
and cost.
* Develop, test, implement, and maintain custom software and system modules.
* Assist in management of all Windows NT application servers and database servers.
* Provide software analysis, detail design specifications, and development estimates.
* Provide programming and data analysis support for the custom intranet/web-based applications.
Provide troubleshooting support for escalated Help Desk problems that cannot be resolved at a
lower level.
* Performs related work as required.