Date: 11-Oct-2019
To see other DBA job opportunities,
please visit http://dba.fyicenter.com/
Database Administrator
Responsibilities:
* Monitoring and maintaining databases
* Performing requested changes, updates and modifications to database structure and data
* Ensuring technical & application development modifications do not adversely affect database integrity, stability and system availability
* Implementing solutions for database backup and recovery infrastructure
* Build operational Maintenance & Operations checklists to maintain the service (daily, weekly, monthly, yearly O & M checklists); build Tactics, Techniques and Processes and Standard Operation Processes associated with service checklists
* Proactively monitoring DB performance, watch database locks, determine their root causes and work with respective team on identifying and implementing corrective actions; detect slow queries and stored procedures, perform query optimizing and drive other performance improvements. Perform re-indexing, data model changes if required.
* Adding or modifying system/user permissions to databases or database servers
* Ensure proactive engagement in Incident Management process, working with cross-functional teams to minimize the impact of database outages
* Generating various reports by querying from database as needed from business or technology departments
Requirements:
* 3-6 years of experience in MS SQL Server Database Administrator and/or held a Senior DBA position
* Expert knowledge of functions associated with the implementation and maintenance of SQL Server 2012 and greater including security, back-up/restoration, logging, reporting and recovery procedures
* Installation and Configuration of multiple instances and versions and components of SQL server, including SQL reporting services, notification services, and analysis services
* Database instance deployments; backup and recovery best practices; production monitoring; etc.
* Support of business and system processes and procedures
* Strong knowledge of DR and HA solutions
* Solid knowledge of system security and best practice
* Experience with Windows Server platforms in relation to SQL installations and upgrades
* Creation of technical documentation
* Strong database design and schema refactoring experience
* Development experience and knowledge of scripting languages including T-QSL, VB Script and PowerShell
* Creation and maintenance of T-SQL stored procedures
* Proven expertise in query optimizing and dramatically improving database performance
* Self-motivated, able to work within a project-based environment
* Detail oriented and organized with an ability to meet deadlines
* Ability to work under pressure and in a fast moving and constantly changing environment
* Experience with cloud technologies such as Azure and AWS stack is a plus.
Job Type: Full-time
Salary: $70,000.00 to $90,000.00 /year
Experience:
in MS SQL Serve Database Administrator: 3 years (Required)
Education:
Bachelor's (Preferred)
To apply for this position, please visit
this Website.
Thank you,
DBA FYI Center
http://dba.fyicenter.com/