We provide IT Staff Augmentation Services!

Sql Server Dba Resume

0/5 (Submit Your Rating)

CA

SUMMARY:

  • Over 7+ years of SQL Server Development and Database Administration experience wif an emphasis on design, development, enhancement, automation, tuning and optimizing databases for highAvailability, Performance and Security.
  • Experience in the Database Design, Analysis, Development, Administration & Supportof MS SQL Server 2005 and 2000in Production, QA & Development environments.
  • Expertise in MS SQL Server Installation, Configuration, Migration and Maintenance.
  • Expertise in SQL Server 2000 Enterprise Edition,experience wifSQL Server Enterprise Manager, SQL Query Analyzer, SQL Server Management Studio and Business Intelligence Development Studio, scheduling jobs wif SQL Server Agent, SQL Server Storage Structures, Index and Security Architecture and SQL Profiler.
  • Applied domain driven methodology for SCRUM application development in C#, and ASP.Net wif TFS 2010/2012/2013 , Visual Studio 2010/2012 and MVC 4.0 framework
  • Experience in supporting web based,mission critical applicationsincludingLogical and Physical Database Design, Development, Performance Tuning and Change Management.
  • Possess strong skills inOperating System Support and Administration, OS Installation & Configuration and Hardware Troubleshooting.
  • Experience in analyzing theFunctional flow of the ProjectsandLeadthe team in database designing and maintenance.
  • Extensive knowledge ofMigrating Databasesresiding on servers in one data center to another andUpgrading Database platformsto newer versions.
  • Possess strong skills in developing processes forImporting, Exporting and Mapping of large volumes of data and integrating wif external systems.
  • Experience in SupportingProduction ServersandApplications 24x7, on - call basis.
  • Expertise in definingDatabase Backup, Recovery and Disaster Recovery Procedures.
  • Extensive knowledge and experience in developingscripts usingT-SQL, SQL and PL/SQL for querying against databases.
  • Expertise in implementing business logic usingTriggers, Views and Stored Procedures.
  • Proficient atPerformance Tuningwif a solid knowledge ofOptimizing CodeandImproving Efficiencyin databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
  • Experience in supportingVeryLarge databases (VLDB),troubleshooting the problems
  • Installed, Configured and MaintainedSQL Server Failover Clusteringfor 3 Production environments.
  • Experience in handlingDatabase performance issues, database capacity issues, Replication, Clustering, Mirroringand other distributed data issues,Encryption.
  • Experience usingdata partitioningwhich is used in splitting large table into few smaller tables.
  • Experience indata warehousing including business intelligence tools-DTS, SSIS and SSRS.
  • Used DTS, SSISfor data migration and data cleansing.
  • Proficient at Documenting all Database Architecture according to established standards, capacity to balance both short and long term issues effectively and handle many simultaneous and often changing priorities.
  • Very Strong on tools such asErwin Data Modeler,Visioand has full understanding of the Software Development Life Cycle.
  • Very good communication skills, good interpersonal skills & desire to excel, fast learner, hardworking and a versatile team player.

TECHNICAL SKILLS:

Relational Databases: SQL Server 2005/ 2000, MS Access, Oracle, Sybase.

Database Technologies/Tools: SQL Server Management Studio, SQL Server Profiler, Repository Manager, SQL Server Enterprise Manager, SQL Server Query Analyzer, Index Tuning Wizard, DTS Import/Export SSIS, SSRS and Crystal reports.

Operating Systems: Windows XP, 2003, 2000, NT, 98, UNIX and Linux.

Network Protocols: TCP/IP on Windows NT 2003/2000

Programming Languages: T-SQL, PL/SQL, C,C++, PERL, TFS,VB.NET and ASP.NET.

Applications: Microsoft Office, Adobe Photoshop.

PROFESSIONAL EXPERIENCE:

Confidential, CA

SQL Server DBA

Responsibilities:

  • Setup and maintainedtransactional replicationOne Publisher and 4 subscriber environment for production servers. These subscribers are located in CT, England and NJ.
  • Setup and MaintainedLog Shippingand worked onCluster setup.
  • Dropped and recreated theindexeson tables for performance improvements.
  • Developed database access layer in C# and created stored procedures, triggers using T-SQL for data access from SQL Server 2008.
  • Worked on creating SQL traces usingSQLProfilerWizardand also efficiently used the PerfMonutility to capture hardware bottlenecks.
  • UsedDBCCutilities, updatedindex statistics, monitored database and disk space; involved in security issues and scheduled tasks.
  • Performed administrative activities like creatinguser loginswif appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups.
  • Successfully migrated databases and queried data wif LINQ C# ASP.Net in Visual Studio 2010/2012 in MVC 3.0 framework wif SQL server 2008 backend and TFS 2010
  • Used toback up user & systemdatabases and restore them when necessary.
  • Created and managedSchema objects such as Tables, Views, and Triggers & maintained Referential Integrity.
  • TroubleshootingDTS packagejobs and nightly batch process jobs 24*7.
  • Worked on 2-10ticketsper day.

Environment: MS SQL server 2000/2005, Windows 2000/2003, Enterprise Manager, Query Analyzer, SQL Server Profiler and SQL Server Management Studio,T-SQL.

Confidential, NJ

Sr. SQL DBA

Responsibilities:

  • Installed and maintainedMS SQL Server 2000 on Windows 2003 Server, according to the company standards.
  • Upgrade experience of SQL Server 2000 to 2005. Experience in applying Service Packs at database and OS Level.
  • MigratedDTSpackages toSSIS(SQL Server Integration Services).
  • Wrote T-SQL queries, Store Procedures and used them to build packages.
  • Assisted wif the implementation ofSnapshotand Transactional Replicationfor the reporting databases.
  • Created theMaintenancePlan for optimization and integrity checkfor all SQL servers.
  • UsedDBCC utilities, updated index statistics, monitored database and disk space; involved insecurity issues and scheduled tasks.
  • Worked onmigration and maintenance of datausing various utilities likeDTS, Import and Export via BCP.
  • Monitored Databases forLockEscalation, Deadlock, resource utilizationby sessions, capturing long running SQL queries, fine-tuning SQL statements dat better result in efficient SQL statements processing.
  • Modified existingStoredProceduresandFunctions.
  • Worked on creatingSQL tracesusingSQL Profiler Wizard.Performed administrative activities likecreating user loginswif appropriate roles, granting and denying login privileges, monitoring the user accounts, creation of groups, granting database and application roles to users and groups.
  • Installed and maintained theFailover Clustering Architecturefor SQL Server databases for mission critical applications.
  • Split large tables usingdata partitioning.
  • PerformedFull Backups and Transaction Log Backups. Restored them whenever necessary; created backup strategies and worked on scheduling the backups.
  • Dropped and recreated theindexeson tables for performance improvements. UsedIndex tuning wizard for tuningof indexes.
  • Automated processes usingSQL Server Jobs.

Environment: MS SQL server 2000/2005, Windows 2003, Enterprise Manager,T-SQL, Query Analyzer, ASP.NET and SSIS.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

  • Created and managedschema objects such as Tables, Views, Clustered and Non-Clustered Indexes and referential integritydepending on user requirements and converting them into technical specifications.
  • Responsible forMS SQL Server 2000 configuration, tuningand provide 24 X 7 dedicated support to all Production, development and clustered servers.
  • Performed all aspects ofdatabase administration, includingdata modeling, backups andrecovery.
  • ConfiguredTransactional replicationbetween Primary Server and three Read - Only servers, wif separate Distributor server and experience in troubleshooting replication problems.
  • Configured theLog shippingand created theStandby server.
  • Created thelogical and physical data modeling using Erwin tool.
  • MaintainedOperators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules.
  • Monitored connections, locks and performance of SQL server.
  • Assignedpermission to users, roles and object, Supportedcolumn level permission. Administeredserver’s logins (Windows and SQL Accounts).
  • Created and grantedpermissions on various Objects.
  • Prepared thereportsfor the day-to-day as well asweekly/monthlypurposes.

Environment: MS SQL-Server 2000, DTS, Erwin, Windows 2003 Server, MS Access, ASP, PERL, MS Analysis Services, Diagnostic Manager, Linux.

Confidential, Atlanta, GA

SQL DBA

Responsibilities:

  • Installation and configuration of SQL Server 2000/2005/2008 components in Development, and Production box applying Service Pack and hot fix.
  • Providing on call support 24/7 on rotational basis for production database on mission critical systems.
  • Creation new database in production and test environment for Development and Test Environment using SQL server 2000/2005.
  • Administration and troubleshooting of SQL server cluster services Active/Active 4 node cluster, load balancing.
  • Designing, testing and managing backup’s and Recovery strategies.
  • Setup, Managing and troubleshooting data Replication.
  • Managing and troubleshooting Mirrored database.
  • Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting.
  • Worked on SQL server centralized alerts and error messaging sending to on call DBA.
  • Creating and managing user accounts / logins for development purpose.
  • Providing support to SOX auditors, providing the backups information for auditing by SOX team, performing restoration of database backup files for SOX purpose, providing trace files for the SOX audit purpose.
  • Migration of database from SQL 2000 to SQL 2005 farm environment.
  • Writing SSIS package to replace the existing DTS packages.
  • Creating SQL stored procedures, views and triggers and managing indexes.

Environment: Windows 2000-Advanced server and Enterprise Server 2003, MS SQL Server 2000/2005/2008 , TSQL, DTS,SSIS, Microsoft Outlook, IBM Lotus Same time 7.5.1.

Confidential, BOSTON, MA

SQL DBA

Responsibilities:

  • Installation and configurationofSQL Server 2005components in Prod/Development, and UAT.
  • Installing and configuring Windows 2003fail overclusterforSQL 2000& 2005.
  • Migrationof windowsClusterand implementationMS SQL 2000 to MS SQL 2005.
  • Migrated DTS packages to MS SQL 2005 SSIS Packagesandtroubleshootingmigration issues and compatibility.
  • AdministrationofClustered SQL serversin24 x 7Windows data center environment.
  • Designing, testingand managingdisk\tape BackupsandRecoverystrategies.
  • ManagingLog Shippingfor warm stand by computers.
  • ManagingReplicationof Data (Snapshot, Transactional, Mergemethod used).
  • Managing SQL databases, Security, fine tuning of SQL queries, troubleshooting.
  • Designing and managingSQL DTSandSSISPackages.
  • Developing SQLstored procedures,viewsandtriggers.
  • Responsible toreleasesfromdevelopmenttotesttoproductionenvironments.

Environment: Windows 2000 Advanced server and Enterprise Server 2003, MS SQL Server 2000/2005 and Oracle, TSQL, Erwin, Flat Files, PL/SQL.

We'd love your feedback!