This job is for a Database Administrator who ensures smooth operation of SQL databases in various environments.
You might like this job because it involves working with different teams to deliver efficient database services and utilizing automation tools for optimization.
Serve as SQL Server DBA providing core database administrative, innovation, support, database infrastructure and architecture design.
Position requires the ability to provide on-call, after-hours/weekend support, when necessary.
ResponsibilitiesInstall, configure, monitor, upgrade and maintain MSSQL databases in production and nonproduction environments.
Work closely with other Infrastructure operations and engineering, product development, business operations, and technical operations to ensure delivery of database services within the SLA's and performance targets set.
Implementation/Support of databases, storage structures, high-availability solutions, replication, encryption, and disaster recovery solutions.
Database administration for applications, ensure continuous 24x7 operation and availability in support of mission-critical business applications and participating in on-call.
Regular database capacity planning and archival solution related to database growth and system utilization, trend analysis, predictive future database resource requirements, and the structured organized reporting of the same.
Participate in the evaluation, selection and implementation of DBA tools to improve the effectiveness of tasks such as performance monitoring and tuning, recovery, and database change management processing.
Proactive and reactive performance analysis, monitoring, troubleshooting and resolution of database issues.
Write/maintain PowerShell scripts for DB automation and application maintenance.
Advance experience with automation of managerial and repetitive DBA tasks.
Job RequirementsBachelors/Degree in Computer Science or other technology field is a must.
Minimum of 4 years of DBA experience with Microsoft SQL Server.
Strong knowledge and extensive experience with Microsoft SQL server technologies (all core areas: SSMS, SQL clustering, Data Synchronization, Encryption, Partitioning, Performance, Security, SSAS, SSIS and SSRS configuration) is mandatory.
Sound knowledge of all windows and SQL utilities; strong PowerShell knowledge and experience is a plus.
Solid understanding of network, storage, tiered application environments and security.
Solid knowledge in database replication technologies (Always-On) and strong architectural/engineering skills to design systems that meet applications High Availability and Disaster Recovery requirements.
Solid knowledge in Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools.
(knowledge of indexes, index management, and statistics)
Demonstrate ability to write complex SQL queries with MS SQL related technologies including T-SQL, stored procedures and database design.
Demonstrate ability to solve complex systems and database environment issues.
A good team player, leader, flexible, share knowledge, help others, collaborate well within and outside the team.
SkillsMicrosoft SQL Servers
Company BenefitsFully work from home to avoid traffic congestion.
Medical & Dental benefits provided to all employees.
We celebrate employees' birthdays as an appreciation of their contributions.
BitCore combines the words " bit " and " core ", two very important words used in technology that are symbolic of what we do.
First off, a "bit" is the most basic unit of information in computing and digital communications.
This represents how technology and IT services are essential in most organizations, becoming one of the basic needs of an organization.
The "core" is the main part keeping everything running.
Without the core, most things would not work.
We are that core, we are BitCore.
We aim to leverage our IT expertise to help our customers save money by providing them with an investment in technological solutions that will help them save costs and make more profit.
We are seeking young Innovative, Aggressive, Highly Motivated and Committed individuals to join our prospective organization.
Our vision is to be SEA's most personalised talent ecosystem; elevating human progress by helping careers and companies grow.#J-18808-Ljbffr