Senior DBA - SQL Server / Oracle LOC:Philadelphia, PA

100,000 - 200,000

Job Description:

Senior Database Administrator who has experience with both MS SQL Server and Oracle databases. Majority of the responsibility will be with SQL Server (85 ndash 90), but some Oracle activities will also be needed. The ideal candidate will also have experience in SQL Server development, particularly SSIS. The position is located in downtown Philadelphia. This is a full time employee position or contract-to-hire position. Contractors will be considered only if there is an option to hire after a 6 month contract period. Responsibilities This role requires a service oriented mentality, high sense of ownership, and a focus on resolving issues. Take a proactive approach to identifying and effectively addressing production issues as they arise. Keep SQL Server performance levels up by identifying current and potential problems and employing best practices to address them. Analyze existing architecture, identify design pain points and develop a strategy to address and prevent future architectural design issues. In collaboration with IT and infrastructure personnel, develop and implement a sound and flexible database backup and recovery strategy. Troubleshoot very complex technical issues and provide reasonable solutions in a timely fashion. Manage disk space and capacity planning. Plan, coordinate and carry out database migrations. Perform SQL Server installs (cluster and non-cluster) and builds Work with clustered systems and Virtual servers. Manage Temp DB logs to ensure that enough space is available and no interruptions of production processes occur. Assist SQL Server developers with optimizing SQL queries, tables, views, triggers, jobs, indexes, partitions and other database performance items. Required Qualifications 5+ years of experience supporting MS SQL Server, preferably 2014 and Windows Server 20032008 2+ years of experience supporting Oracle 9i, 10g, andor 11g Experience as a Database Administrator designing, tuning and administering database systems (emphasis on SQL Server with some work on Oracle) Knowledge of and ability to install, configure and tune SQL Server Clusters. Experience working in cluster and virtual environments Experience with batch scripting, T-SQL, SQL programming, query optimization, setting indexes, table partitions, triggers, etc. Experience in creating DB userslogins and security management Ability to run traces, performance monitoring, blocking and good problem solving skills Experience with SQL installations and replication setup Experience with routine database maintenance operations - modifying SQL Agent jobs, backups and restores, knowledge of re-indexing Experience working with multiple databases and multiple SQL servers in a production and non-production environment Bachelor\'s Degree in MIS, IT, Computer Science or related field. Equivalent technical experience may be substituted for educational requirement Additional Desired Qualifications Knowledge of Data Warehouse and Data Integration technology is highly desirable SQL Server development experience in SSIS Local to the Philadelphia area Please send your resume and compensation requirements to ITjobs1ces-ltd.com mailtoITjobs1ces-ltd.com SQL Server, SSIS, SSRS, DBA, data warehouse, partitions, performance, T-SQL

Share Profile