Sr. sql dba
Company Name:
Open Systems Technologies
Database Administrator
Activities include the definition of needs, benefits, and technical strategy; research & development within the database systems life-cycle; technical analysis and design; and support of operations staff in executing, testing and rolling-out solutions.
Responsibilities
? Working with applications groups to performance tune and troubleshoot SQL code
? Working with business units and developers to map out conceptual designs for planned databases
? Installing and testing new versions of the DBMS, specifically MS SQL Server 2012
? writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata);
? controlling access permissions and privileges to adhere to SSAE16 audit controls
? Developing, managing and testing back-up and recovery plans
? Developing, managing and tuning of SQL Server Replication
? Knowledge of C#/Java is a plus.
? ensuring that storage, archiving, back-up and recovery procedures are functioning correctly
? communicating regularly with technical, applications and operational staff to ensure database integrity and security
? Engineering of database related solutions for various project and operational needs.
? Develop and maintain installation and configuration procedures; contribute to and maintain system standards; create and maintain documentation as it relates to configurations
? Research and recommend innovative, and where possible automated approaches for database administration tasks. Identify approaches that leverage our resources and provide economies of scale.
? Perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.
? Perform regular security monitoring to identify any possible intrusions.
? Provide database support per request from various departments. Investigate and troubleshoot issues.
? Perform periodic performance reporting to support capacity planning.
Requirements
? BE or BS Degree in one of the following subject areas: Computer Science, Information Technology or related field preferred
? 10
years in Information Technology
? 10
years IT operation with strong understanding of database structures, theories, principles, and practices
? 10
years Microsoft SQL Server experience
? Experience is Microsoft SQL Server Analysis Server a plus
? Proficiency in TSQL
? Strong MDX a plus
? Understanding of, and experience with, server-client computing and relational database environments
? Experience with data management and data processing flowcharting techniques
? Knowledge of reporting and query tools and practices
? Good interpersonal, written, and oral communication skills
? Technical documentation skills
? Self-motivated and directed, with keen attention to detail
? Able to prioritize and execute tasks in a high-pressure environment
? Experience working in a team-oriented, collaborative environmentEstimated Salary: $20 to $28 per hour based on qualifications.
Open Systems Technologies
Database Administrator
Activities include the definition of needs, benefits, and technical strategy; research & development within the database systems life-cycle; technical analysis and design; and support of operations staff in executing, testing and rolling-out solutions.
Responsibilities
? Working with applications groups to performance tune and troubleshoot SQL code
? Working with business units and developers to map out conceptual designs for planned databases
? Installing and testing new versions of the DBMS, specifically MS SQL Server 2012
? writing database documentation, including data standards, procedures and definitions for the data dictionary (metadata);
? controlling access permissions and privileges to adhere to SSAE16 audit controls
? Developing, managing and testing back-up and recovery plans
? Developing, managing and tuning of SQL Server Replication
? Knowledge of C#/Java is a plus.
? ensuring that storage, archiving, back-up and recovery procedures are functioning correctly
? communicating regularly with technical, applications and operational staff to ensure database integrity and security
? Engineering of database related solutions for various project and operational needs.
? Develop and maintain installation and configuration procedures; contribute to and maintain system standards; create and maintain documentation as it relates to configurations
? Research and recommend innovative, and where possible automated approaches for database administration tasks. Identify approaches that leverage our resources and provide economies of scale.
? Perform daily system monitoring, verifying the integrity and availability of all hardware, server resources, systems and key processes, reviewing system and application logs, and verifying completion of scheduled jobs such as backups.
? Perform regular security monitoring to identify any possible intrusions.
? Provide database support per request from various departments. Investigate and troubleshoot issues.
? Perform periodic performance reporting to support capacity planning.
Requirements
? BE or BS Degree in one of the following subject areas: Computer Science, Information Technology or related field preferred
? 10
years in Information Technology
? 10
years IT operation with strong understanding of database structures, theories, principles, and practices
? 10
years Microsoft SQL Server experience
? Experience is Microsoft SQL Server Analysis Server a plus
? Proficiency in TSQL
? Strong MDX a plus
? Understanding of, and experience with, server-client computing and relational database environments
? Experience with data management and data processing flowcharting techniques
? Knowledge of reporting and query tools and practices
? Good interpersonal, written, and oral communication skills
? Technical documentation skills
? Self-motivated and directed, with keen attention to detail
? Able to prioritize and execute tasks in a high-pressure environment
? Experience working in a team-oriented, collaborative environmentEstimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
