Database Senior Analyst
Loews Corporation - White Plains, NY

This job posting is no longer available on Loews Corporation. Find similar jobs:Database Senior Analyst jobs - Loews Corporation jobs

The Senior Database Analyst will implement database and application systems; participate in database and application architecture review, capacity planning, database and application installation and configuration, standard database management procedure setup, as well as application specific database and application procedure development.
Enhance and develop more robust database and application administration automation procedures using SQL Scripting, PowerShell 2.0 and 3.0 along with SMO and WMI, Perl and Unix Shell Scripting. The procedures include daily database disaster recovery (DR) information generation, database backup reports, error checking, alert on monitoring results, various output file rollover, space usage, scheduled job running status, detection of database changes at all different levels.

* Leverage all the DBA tools and DBA developed procedures to monitor, tune and optimize database and application performance
* Under general direction test, implement, maintain and control the organization’s (Loews Corporation and Loews Hotels) databases across multiple platforms such as MS SQL 2005, MS SQL 2008, Oracle, and DB2 databases on a MS Windows Operating System Server platform
* Monitor transaction activities and improve the performance of all databases
* Report abnormal discrepancies to the Database Manager
* Participate in meetings in the development of standards and procedures affecting database management, design and maintenance
* Work with Senior Database staff by maintaining databases for test and production purposes for assigned projects
* Monitor the performance of all databases for the organization (Loews Corporation and Loews Hotels)
* Monitor all database backups and report any failures of this process
* On a project basis, monitor and provide statistical information on system and application performance and provide recommendations for corrective actions to the Manager of Database

Qualifications :
* Minimum of four years in the design and administration of logical and relational databases in diverse and technological environments, in file structures, design and retrieval, access methods, control and development of standards, or an equivalent combination of education and work experience
* Required excellent analytical ability, strong communication skills, strong judgment and the ability to work effectively with IT Management and IT staff members
* Possess a strong background and technical skills working with the following database platforms: Oracle on Windows Operating System, MS SQL 2008 and MS SQL 2005. Strong SQL scripting as well as a good knowledge of scripting skills for PowerShell, Perl and Shell Scripting to manage databases, applications and Operating Systems
* Required knowledge and strong technical background working with the following RDBMS platforms, MS SQL 2008, MS SQL 2005 and Oracle Database 10G
* Exposer to MS SQL 2012 and DB2 is a plus
* In-depth understanding of Relational Database Design, MS SQL Business Intelligence, MS SQL Report Server, MS SQL Database Mirroring and Log Shipping
* Knowledge and hands-on of Oracle RMAN Backup and Restoration, Oracle Real Application Cluster (RAC), Oracle Automatic Storage Management (ASM) and Oracle Data Guard will be plus
* Strong knowledge of Database Structured Query Language (SQL) and SQL Scripting
* Good knowledge of scripting skills involving in Microsoft PowerShell, Perl and Unix Shell Scripting to manage databases, applications and operating system related tasks
* Good understanding of the underlying operating systems, particularly Windows Server 2008, Windows Server 2003 and Solaris Unix
* General understanding of distributed computing architecture, for example, Client/Server, Internet/Intranet and Enterprise
* Familiar with some database development and management software products, for example DBArtisan, ERStudio and Performance Center from Embarcadero, PowerBroker Database Assessment from BeyondTrust, Toad for Oralce and LightSpeed Engine for Oracle from Quest

Education :
*Bachelor's Degree in Computer Science or equivalent experience

Location: US: NY: White Plains

About this company
8 reviews
Loews Corporation is a diversified company with three publicly-traded subsidiaries: CNA Financial Corporation (NYSE: CNA), Diamond Offshore...