Norristown, PA - SQL Server DBA

JOB DESCRIPTION

• The SQL Server database administrator (DBA) is responsible for ensuring the security, availability, integrity, and functionality of production databases
• The DBA works with the development team to identify optimal physical implementation of the logical model
• The DBA is also responsible for monitoring the production databases and providing support, including problem identification and remediation, as well as performance monitoring
• The production DBA will ensure that all changes to production databases are fully tested and are secure against unauthorized access and accidental damage
• The DBA will also assist is infrastructure work to standardize the SQL Server DB environment

The scope of responsibility for the position includes project support, as well as maintenance and support activities

REQUIREMENTS:

• B.S. degree in computer science, management information systems, or equivalent work experience
• Ability to work independently
• Ability to manage multiple concurrent objectives, projects, or activities
• Experience tuning individual SQL queries, database applications, and optimizing databases for performance
• Experience supporting SQL Server databases 2000 and 2005
• Experience in the Windows 2003 Server Operating System
• 5 years of relevant experience
• Experience with logical data modeling, including developing and maintaining data model diagrams (ERD), facilitating structured data modeling meetings
• Experience working in a highly available 24X7 database environment
• Experience with installation, configuration and management of enterprise SQL Server databases in a clustered environment
• Installation considerations
• Installation validation
• Installation configuration
• Database mirroring
• Log shipping
• Upgrade to SQL Server 2005/2008
• Patch management
• Strong customer and business focus
• Strong documentation and communications skills
• Experience working with very large databases
• Knowledge of page and extents
• Files and filegroups
• Transaction logs
• Knowledge of database, table, index, partitions and view storage structure
• Experience migrating database objects from development through test and into production
• Experience monitoring events, log files and resource usage
• Provide production DBA support for multiple customer facing applications
• Work with development and support teams to identify and address performance problems
• Ensure that databases are in compliance with company standards, as well as all relevant configuration determined by DBA team
• Perform account management, in accordance with requests from Security group

Required Technical Skills:

• Experience managing database operations
• Services / Transaction log management
• Backup and restoration
• System database rebuilding
• Import/Export of data
• Copy/move data between servers

Preferred Technical Skills:

• Experience with SSIS, SSRS
• Experience working in a formal software system delivery methodology
• Provide production DBA support for multiple customer facing applications
• Support development of physical data model and scripts for application development
• Design physical model for performance (denormalize; add indexes)
• Work development and support teams to identify and address performance problems
• Manage database backups and participate in recovery exercises
• Perform necessary database upgrades and patches
• Ensure that databases are in compliance with company standards, as well as all relevant configuration determined by DBA team
• Perform account management, in accordance with requests from Security group

SUBMIT RESUME to Resume@ABOUT-Consulting.com

 Please Include Job Title and Location in the Subject Line of Your Email