| Designation | Software Engineer / Senior Software Engineer - 14 Opening(s) | |
| Job Description | • Database server Installation • Backup and recovery • Performance tuning • Clustering, Log shipping • Replication • Database mirroring Database Server level points 1) Analyze the server configuration e.g. Processor, disk, RAM etc. 2) Determine whether the customer faces performance issues during a certain period of time or during the peak time. Also, check the performance issues are consistent or random. 3) Run Performance monitor and check the usage of different parameters including network parameters, memory, I/O parameters, sql specific parameters etc. during peak time and non peak time. Record both. 4) Analyze whether the database server and application server are different or both are on the same machine 5) Analyze whether any other third party application is running on the database or application server 6) Analyze whether any other server application is using the production database. 7) Analyze whether sufficient free space is available on the server. 8) Analyze the backup strategy in use. 9) Analyze the server maintenance plan 10) Analyze whether any data upload activity takes place on a given time. 11) Analyze whether SSIS packages are used. 12) Analyze the jobs in use and their execution time 13) Analyze whether any replication or clustering is implemented or not 14) Check whether any linked servers are in use 15) Check if the database was migrated from a previous version of SQL Server or any other database server. Database level points 1) Analyze whether dynamic queries are being used in database stored procedures, application code and crystal reports. 2) Identify long running stored procedures or long running application parameters. (Use SQL profiler for this. Also take end users help for this as they can pinpoint the application pain areas) 3) Analyze the queries written in the long running stored procedures at a high level and identify the issues using execution plan or profiler. 4) Analyze whether required indexes are created or not 5) Analyze whether unnecessary indexes have been created 6) Analyze whether the indexes created are actually used by the optimizer or not 7) Analyze whether the statistics are updated or not 8) Analyze whether heavy views are used in the queries. Also check whether the indexed views have been used or not. 9) Analyze whether triggers are being used and ther performance thereof. 10) Analyze whether cursors are being used 11) Analyze the transaction management implemented 12) Check the deletion method followed - is it soft delete or hard delete 13) Analyze the number of locks acquired when the application gives performance issues 14) Check whether any deadlocks occur or not 15) Check whether large number of records are fetched from the application for a given operation. Check the performance here. 16) Determine the number of master and transaction tables and whether required indexes are created on the master tables. 17) Check whether primary keys have been created on critical tables. 18) Check whether temporary tables are used on a large scale thereby hitting the tempdb database and increasing disk I/O. 19) Check whether normalization has been followed or not 20) Analyze whether DB best practices are being followed or not for both the database schema and queries. | |
| Desired Profile |
| |
| Experience | 3 - 7 Years | |
| Industry Type | IT-Software/ Software Services | |
| Role | DBA | |
| Functional Area | DBA, Datawarehousing | |
| Education | UG - B.Sc - Any Specialization,B.Tech/B.E. - Any Specialization PG - Any PG Course - Any Specialization,Post Graduation Not Required | |
| Location | Mumbai | |
| Keywords | SQL DBA, SQL server DBA, | |
| Company | Patni Computer Systems Ltd | |
| deya.bandyopadhyay@patni.com | ||
| Website | http://www.patni.com | |
| Reference | IMS 03 | |
0 comments:
Post a Comment