Duration: Full Time (Perm)
Location: 15219 Pittsburgh, PA
Rate: $84,600
Exact compensation may vary based on several factors, including skills, experience, and education.
Must Haves:
• Bachelor's degree required
• Minimum 6 years of professional IT experience
• Database design, development and programming using stored procedures
• Experience in SQL Server installation and maintenance
• TSQL and SQL scripting
• SSIS and SSRS
Plusses:
• Oracle Database experience
• Experience converting an Oracle database to SQL
• Back end development
Day to Day:
Insight Global is looking for a Senior SQL DBA to help with a local client. This position's responsibilities include the administration, maintenance, development and implementation of policies and procedures for ensuring the security and integrity of Databases. They will be responsible for a large project focusing around converting an Oracle Database to SQL before it expires. Following the project this person will take on a Senior DBA role and perform basic tasks such as software installation and maintenance. The creation and performing of tests also will be done by the Senior DBA.
• Performs SQL Server software installation, maintenance and conversions
• Maintains multiple databases in development and production environments
• Works with development teams on all aspects of database design including tables, views, stored procedures, permissions, etc.
• Performs logical database design and physical database implementations.
• Creates, tests, and conducts performance tuning on databases.
• Develops SQL processes for data loading, migration and application interfaces.
• Develops and implement backup and recovery strategies.
• Creates deployment scripts, including rollback scripts, for all database changes.
• Monitors daily SQL processes for successful completion.
• Troubleshoots production problems and be a key part of the first level support team to investigate and resolve issues.
• Performs security configuration and administration.
• Develops and enforce organizational SQL standards and best practices.
Location: United States
Posted: Aug. 19, 2024, 7:18 p.m.
Apply Now Company Website