SQL Server Database Administrator
Published date: 2024/01/10
- Location: New delhi, India
Manage and support of the SQL Server Databases, routine tasks in support of Senior SQL Database administrators.SQL DBA will possess the following experience :- Production Activities- Ensure active and effective backup policies in place.- Monitor system for performance and load issues.- Apply system patches as appropriate.- Manage execution of application patches and ensure rollback strategy is in place.- Performance monitor system for slowest queries and provide regular report to development team.- Profile T-SQL and fine-tune queries through hints, application of keys or restructuring of query.- Plan for future scale and performance needs based upon historical data and projected system growth.- Resolving database maintenance and corruption issues.- General Trouble-shoot issues in all environments as and when needed.- Build automation scripts for DB maintenance using a scripting language such as PowerShell, VBScriptSkills Required and Responsibilities :- 7+ years-
of experience in SQL Server Database administration/development.- Support daily DBA activities including maintenance operations not limited to Backups, Restores & Index rebuilds.- Ability to support Always on( FCI and AG) for HA and Log Shipping, Mirroring for DR in SQL Server 2012/2014 .- In-depth knowledge of Windows Operating system & Storage internals.- Support database related security and audit all database events in DBA ticketing system.- Should have good knowledge in SQL Server DMV- s, DMF's and system catalog views.- Proficient in writing T-SQL scripts for SQL Server automation and scheduling jobs through SQL Agent- Troubleshooting SQL Server with tools like SQL Server extended events, SQL Profiler, Database tuning advisor for any major application issues.- Support SQL Server Integration Services jobs and work with teams related to any issues.- Recommending & Implementing Microsoft Best practices in environment.- Microsoft certified professional is plus. Skills:- SQL server, MySQL and
DBA
of experience in SQL Server Database administration/development.- Support daily DBA activities including maintenance operations not limited to Backups, Restores & Index rebuilds.- Ability to support Always on( FCI and AG) for HA and Log Shipping, Mirroring for DR in SQL Server 2012/2014 .- In-depth knowledge of Windows Operating system & Storage internals.- Support database related security and audit all database events in DBA ticketing system.- Should have good knowledge in SQL Server DMV- s, DMF's and system catalog views.- Proficient in writing T-SQL scripts for SQL Server automation and scheduling jobs through SQL Agent- Troubleshooting SQL Server with tools like SQL Server extended events, SQL Profiler, Database tuning advisor for any major application issues.- Support SQL Server Integration Services jobs and work with teams related to any issues.- Recommending & Implementing Microsoft Best practices in environment.- Microsoft certified professional is plus. Skills:- SQL server, MySQL and
DBA
0 page views
Related listings
-
Jr . Sales AdministratorDatabase AdministratorJob Description Maintain update the daily sales stock data to HO. Updating supervising cash, cheque and credit outstanding of the customer. Making a list of the invoice for the payment of organized retailer. Managing a petty cash (Petrol/Diesel, park...2024/01/10
-
AdministratorDatabase AdministratorAlso known as office administrators or office managers, administrators support office operations and leadership by keeping workspaces and information organized and accessible. They handle planning and clerical activities such as answering phones; upd...2024/01/10
-
Computer Operator Data EntryDatabase AdministratorQualifications Higher Secondary(12th Pass) (Required) Typing Language - English (Required) Work Type - Data Entry Full Job Description Need computer operator - Data Entry who is proficient in English typing and online Work. For more Details Please Vi...2024/01/10
Useful information
- Avoid scams by acting locally or paying with PayPal
- Never pay with Western Union, Moneygram or other anonymous payment services
- Don't buy or sell outside of your country. Don't accept cashier cheques from outside your country
- This site is never involved in any transaction, and does not handle payments, shipping, guarantee transactions, provide escrow services, or offer "buyer protection" or "seller certification"